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.
I have a report that is filtered by the Week_End_Date, one of the visuals looks at the previous month data, however, when I select the slicer to view a Week_End_Date such as 6/5/2021 (when the previous month ended in the currently selected week) the filtering won't show the new previous month until the Week_End_Date of 6/12/2021 is selected. I hope this made sense.
While the numbers are right, I want the filters to show the real previous month in these instances.
The Calculation i am using is show below...
Calendar Table
Solved! Go to Solution.
@Anonymous , previous month consider first date in context. Try datesmtd with endofmonth
% Below 30 CALC =
var _max = maxx(allselected(),'CALENDAR'[REPORT_DATE])
CALCULATE (
values('% BELOW 30'[% Below 30]),
DATESMTD(ENDOFMONTH('CALENDAR'[Date])))
@Anonymous , previous month consider first date in context. Try datesmtd with endofmonth
% Below 30 CALC =
var _max = maxx(allselected(),'CALENDAR'[REPORT_DATE])
CALCULATE (
values('% BELOW 30'[% Below 30]),
DATESMTD(ENDOFMONTH('CALENDAR'[Date])))
This worked! Thank you so much!
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 |
---|---|
108 | |
98 | |
81 | |
65 | |
62 |
User | Count |
---|---|
147 | |
116 | |
104 | |
88 | |
65 |