Forum Discussion
Circular dependency in columns with different dates
Hello, 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...
Hi Tasos,
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])))
Regards,
Frank
Hi v-frfei-msft,
Unfortunately, your approach was not what I am looking for. I am currently trying 101Mathew's solution working in Power Editor, although I am not sure how this can help.
Thank both of you for your time,
Tasos