Forum Discussion
Power BI Dax Measure
I have two columns in a line and clustered column chart which shows one with number of cases received in one week and the other shows number of cases resolved in the same week. For suppose in week 33...
Deepak_22
Helper I
Helper IHello Anonymous , I understand that you have measures for "Cases Received This Week" and "Cases Resolved This Week." In that case, you can create the "Balance" measure as a calculated measure based on these measures.
Assuming you have the following measures:
Cases Received This Week as [ReceivedThisWeek]
Cases Resolved This Week as [ResolvedThisWeek]
You can create a new measure for the "Balance" as follows:
Balance = [ReceivedThisWeek] - [ResolvedThisWeek]
If you find this helpful, please provide a kudo and mark it as an accepted solution.