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.
Hi SrivatsaB
Calculating the beginning, YTD and ending balances is pretty simple but what complicates your use case is you are attempting to add an extra row (beginning or possibly ending) which most likely doesn't exist in your fact table. Matrix in Power BI works just like a Pivot table in Excel, you can't just add add custom rows/columns and still make it work like you are editing a range of cells.
Attached is a sample pbix to help you get started with.