Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello there,
i have a Slicer of Monthname where the User can choose more than one Month. i am searching for a Dax- Formula where the Measure returns the Max of the choosen Months.
for example: if MonthName Slicer got Jan, Feb and Mar as selected Values... Mar should be the Result
i tried already a Measure with MonthNumbers but with MonthName the Result is not the Same...
https://www.dropbox.com/s/9nqmwxxw7ezckc1/sample.pbix?dl=0
Solved! Go to Solution.
Hey @corp_scorp,
You could try this measure:
Max Month Number of selected Values =
VAR _max_month_number =
MAX ( 'Date'[MonthNumber] )
RETURN
CALCULATE (
SELECTEDVALUE ( 'Date'[MonthName] ),
'Date'[MonthNumber] = _max_month_number
)
Hey @corp_scorp,
You could try this measure:
Max Month Number of selected Values =
VAR _max_month_number =
MAX ( 'Date'[MonthNumber] )
RETURN
CALCULATE (
SELECTEDVALUE ( 'Date'[MonthName] ),
'Date'[MonthNumber] = _max_month_number
)