I'm hoping someone can help me figure out how to accomplish this being new to Power BI. I'm more a MS-SQL and Crystal Reports, Excel person so this has stumped me.
I'm including two screenshots below, the first is what I want to accomplish and the second is where I'm at. Right now I'm using a matrix table for my visualization.
Most of the data is imported and then I created three measures (PREVIOUS MONTH, BEFORE PRIOR MONTH, and GROSS CHARGES). These are calculated as follows:
The data is filtered for a date range of 6/1/16-7/1/17. Here are some of the problems I'm having.
Anyway, I'm really hoping someone can steer me towards the right direction.
Thank you in advance for your help.
The figures for in the Grand Total column for the "Previous Month" and "Before Previous month" measures should be blank. These measures make sense only for a particular month (not multiple months). In PBI desktop, i dont think you will get an answer to question 3. In Excel, question 3 can be answered by writing CUBE functions.
Thank you for replying.
Is there no work around to having Power BI give me totals (as a column) to all three then? Is this the same problem as #3?