The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I am trying to create a DAX measure called Selected Date that displays the maximum selected date and keeps it static. This means that if Nov 2017 is selected, I want the Selected Date column to show 11/1/2017 next to every month. I'd ideally like to use the 2nd type of slicer (shown below).
My current measure is Selected Date = SELECTEDVALUE('Date'[Month]).
I do not want the Selected Date to change if it is sliced by a Month in a table. How can I do this?
Solved! Go to Solution.
To answer my own question, the DAX query would be:
Selected Date = MAXX(ALLSELECTED('Date'[Month]),'Date'[Month])
To answer my own question, the DAX query would be:
Selected Date = MAXX(ALLSELECTED('Date'[Month]),'Date'[Month])
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
82 | |
63 | |
54 | |
52 |
User | Count |
---|---|
127 | |
118 | |
81 | |
65 | |
64 |