Forum Discussion

Tasos's avatar
Tasos
Icon for Helper II rankHelper II
7 years ago

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...
General Comment
Need Help
Show and Tell
v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

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

 

101Mathew's avatar
101Mathew
Icon for Advocate V rankAdvocate V
7 years ago

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.

 

Regards,

Mathew