Forum Discussion
sabd80
Helper IV
Helper IVCalculated Column error Circular dependency
Hi, I am trying to create a few calculated columns from one table. I had no issue creating the first one, Actual: Actual = CALCULATE(sum('Consolidated Sales'[GrossSalesValue]),'Consolidate...
I solve it.
Budget=IF('Consolidated Sales'[Source]="Budget", 'Consolidated Sales'[GrossSalesValue])
DivkLearner
Resolver I
Resolver IHello sabd80,
I tried the same sample and found the solution is to use "Measure" instead of "Calculated Column".
Let me know if you are looking for something specific and I can help you with it.
Regards,
DivKlearner, A bit forward daily.
Link to my channel on Power BI.
https://www.youtube.com/watch?v=aADx2sPA2D0&list=PLDUIC70xSiVQQpfqGhOjBVDF8IBP2k6ob