Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello guys!
I have a question for which I haven't found the solution yet. Can you help me?
I have 3 cards on my report screen. When I select any month I would like the first card to show the selected month and the other two the subsequent months from the first card
For the first card I already have the solution, I just drag the month field from the calendar table to the card, but for the others I don't know how to do it.
Example:
If I select JANUARY the first card will show the text JANUARY, the second will show FEBRUARY and the third one MARCH.
Do you know how I can get these values from the calendar filter selection?
Thank you very much in advance
Solved! Go to Solution.
Hi,
Assuming the slicer has been built from the Calendar Table, write these measures
Selected month = format(max(Calendar[Date]),"mmmm")
Selected month + 1 = format(max(Calendar[Date])+1,"mmmm")
Selected month + 2 = format(edate(min(Calendar[Date]),2),"mmmm")
Hope this helps.
This is a bit hacky, but you can shift by X months like this:
= FORMAT ( EOMONTH ( DATEVALUE ( [Month Name] & " 2000"), X), "mmmm" )
For X = 2, DATEVALUE transforms "January 2000" into DATE(2000, 1, 1), shifts it forward 2 months using EOMONTH to DATE(2000,3,31), and formats this as "March" using the custom FORMAT string "mmmm".
This is a bit hacky, but you can shift by X months like this:
= FORMAT ( EOMONTH ( DATEVALUE ( [Month Name] & " 2000"), X), "mmmm" )
For X = 2, DATEVALUE transforms "January 2000" into DATE(2000, 1, 1), shifts it forward 2 months using EOMONTH to DATE(2000,3,31), and formats this as "March" using the custom FORMAT string "mmmm".
Thanks a lot for the help! It worked correctly!
Hi,
Assuming the slicer has been built from the Calendar Table, write these measures
Selected month = format(max(Calendar[Date]),"mmmm")
Selected month + 1 = format(max(Calendar[Date])+1,"mmmm")
Selected month + 2 = format(edate(min(Calendar[Date]),2),"mmmm")
Hope this helps.
Hi,
it just didn't work in the month of December, it should change to January, but it kept showing January. For the remaining months it worked correctly.
I ended up using the solution that the other colleague indicated, even so I thank you for his help.
Ensure that the last date in the Calendar table is a December 31, 2023.
Perfect! Thank you again!
You are welcome. Please mark that reply of mine as the Answer in which i shared the 3 measures.
Done!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
93 | |
85 | |
83 | |
72 | |
49 |
User | Count |
---|---|
142 | |
135 | |
110 | |
68 | |
55 |