Forum Discussion
Solved
Create Measures with Circular Dependency.
I am trying to convert an excel data output to PowerBI and the measures actually have circular dependency. Can someone help me with a solution? 1.Beginning for first month has to be deri...
Please see the sample pbix in my previous reply which was based solely on the initial data provided.
Thanks for your response danextian . You are right on Ending, we don't have that in table.
I have Beginning , Category A & Category B from the table. Category C is based out of a whatif parameter, Category D is the previous month value.
Now my ending is, Beginning + Category A + Category B + Category C + Category D.
This ending has to be called up to the February Beginning section.
Please see the sample pbix in my previous reply which was based solely on the initial data provided.