Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
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.
Hi,
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.
Hi Ashish,
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?
Thanks
Hi,
I am not sure of what you mean by your first sentence. Question 3 can be solved by writing CUBE functions in Excel.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |