I'm trying to create a new column in Power BI Desktop which replicates a basic Excel formula which seems simple enough.
The Excel formula which I am trying to replicate is in column D:
=IF(B2=B1, 0, C2)
So that the returned column should look like column D.
Excel Data Example:
I have the same data structure in Power BI and would like to create a new column to replicate column D in Excel, but I can't find a way to replicate the formula in DAX where it calls for :
B2=B1
Power BI Data Example: