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.
Hey guys,
hope you can help me out with this one.
I have a filter on month names (for simplicity let's imply the year is always 2022):
And another slicer that allows period selection (MTD/Full). I'm already calculating the sum over the selected period.
Now, what I want to achieve is, that it is only calculating the sum and displaying it in a bar chart for the most recent month selected (e.g. March) when the user has MTD selected.
I did the calculation like that:
Solved! Go to Solution.
@Anonymous , Create a measure
measure =
var _max = eomonth(maxx(allselected(Dates) , Dates[Date]) ,0)
return
calculate(sum(Table[Value]), filter(Dates, eomonth(Dates[Date],0) =_max)
@Anonymous , Create a measure
measure =
var _max = eomonth(maxx(allselected(Dates) , Dates[Date]) ,0)
return
calculate(sum(Table[Value]), filter(Dates, eomonth(Dates[Date],0) =_max)
@amitchandak
Thanks for your reply. Solved my issue with the MTD calculation. But I'm not able to transfer your example to a YTD calculation. If a user selects YTD, I want to show all months of the most recent year in a bar chart, despite the fact that the user might have not selected all months. How do I deal with this?
Appreciate your help!
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 |
---|---|
21 | |
15 | |
14 | |
11 | |
7 |
User | Count |
---|---|
26 | |
23 | |
12 | |
11 | |
10 |