Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello all,
I have a request here to have fincial information side by side in a matrix. Revenue (Which is total revenue by category based on date slicer selection), and Rolling Total Revenue which is also by category but not based on date. I've created a copy of my main date table and not created any relationships to it and created the below measure. Unfortunately this is just giving me blanks regardless of date selections. Any assistance here would be appreciated.
Revenue: //Working as expected
Solved! Go to Solution.
Hi @BDale93 possible solution as following:
If you do not have Date, Calendar Table please create one and connect it with your table (time_card_by_day_with_cost). Check link below if you need instruction for creation of Date table.
In example below 'Date'[Date] column is key colum for conection your table and Date is name of Date table, so adjust name accordingly.
After that create measure
Cumulative Total Test=
VAR __max_date = MAX ( 'Date'[Date] )
RETURN
CALCULATE (
SUM(time_card_by_day_with_cost[Total Revenue]) , -- simple sum or your measure [Revenue]
'Date'[Date] <= __max_date,
ALL ( Date )
)
Create Calendar Table Microsoft Learn
https://learn.microsoft.com/en-us/power-bi/guidance/model-date-tables
Did I answer your question? Kudos appreciated / accept solution!
Proud to be a Super User!
Hi @BDale93 possible solution as following:
If you do not have Date, Calendar Table please create one and connect it with your table (time_card_by_day_with_cost). Check link below if you need instruction for creation of Date table.
In example below 'Date'[Date] column is key colum for conection your table and Date is name of Date table, so adjust name accordingly.
After that create measure
Cumulative Total Test=
VAR __max_date = MAX ( 'Date'[Date] )
RETURN
CALCULATE (
SUM(time_card_by_day_with_cost[Total Revenue]) , -- simple sum or your measure [Revenue]
'Date'[Date] <= __max_date,
ALL ( Date )
)
Create Calendar Table Microsoft Learn
https://learn.microsoft.com/en-us/power-bi/guidance/model-date-tables
Did I answer your question? Kudos appreciated / accept solution!
Proud to be a Super User!
Thanks some_bih (lol),
This isnt exactly what I was looking for but I think suffices for the ask. For example, with this measure if I have October 2023 selected, Revenue for the month calculates correctly and Total Revenue does as well. However, if I switch to September 2023 Revenue for the month calculates correctly and Total Revenue calculates through September 2023 as well, where I was trying to get that to remain as totaling through October 2023 (The max date in the model). This is why I was trying to use a second date table for the total columns. Regardless, this should do and thanks for the assistance.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
146 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
218 | |
88 | |
73 | |
64 | |
60 |