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,
I have a table that has all the month end dates in and products along with there value for that month.
This table is linked to a calendar table (which is a date table). Many to one (both)
In the report I use the month and year from the calendar table to filter the data, this works fine for the month/year (one slicer is year and teh other is month) selected but when I try and show the previous months data alongside I just get blanks.
The data table (GetMRRdata_overall) structure is
MonthEnd this is linked to date in Calendar
Product
Value
The calc I have tried is
Solved! Go to Solution.
Hi @Anonymous ,
You can create a measure like DAX below.
PreviousMonth = CALCULATE(SUM(GetMRRdata_overall[MRR]),DATEADD('t_Calendar'[Date],-1,MONTH))
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I Have tried the following but I only get the overall total against all the products not the individual totals :
Think I have sorted it (I changed the calendar table name so it didnt confuse with preffered name, this wasnt the answer though)
Hi @Anonymous ,
You can create a measure like DAX below.
PreviousMonth = CALCULATE(SUM(GetMRRdata_overall[MRR]),DATEADD('t_Calendar'[Date],-1,MONTH))
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you Amy, this is much better 🙂
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 |
---|---|
113 | |
99 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |