I am trying to recreate a relatively easy calculation in Excel in PowerBI. However, it returns a circular dependency.
In Excel, I don't have this issue as, although I use data from the same column, I am using a different row. I have tried to use the calculate function as it is proposed in previous posts regarding the circular dependency, but with no success.
Thank you for your support!!
We can create measures to work on it, then we will get no error.
awd0m = CALCULATE(SUM(Table1[Demand]))
awd1m = CALCULATE(SUM(Table1[Demand]),DATEADD('Table1'[Date],-1,DAY))
awd2m = CALCULATE(SUM(Table1[Demand]),DATEADD('Table1'[Date],-2,DAY))
CWD2M = IF(ISBLANK([awd1m]),BLANK(),IF(MAX(Table1[Capacity])>[awd2m],[awd2m],MAX(Table1[Capacity])))
@TasosI agree with you solution, if the original data is still required otherwise cut down the on the data loaded into the report when possible.