topic Incorrect Month displayed when selecting full year in single choice filter in DAX Commands and Tips

Incorrect Month displayed when selecting full year in single choice filter

tjordan08 — Thu, 11 Apr 2024 09:56:14 GMT

Hello, I have a dashboard that is showing the month /year based on a single choice filter and it works ok, except for when I select the full year ‘2022’ which selects all months up until December. The month in this case displays 'September' (being the last month based on alphabetical order.), but it should show “December’ instead being the last month of the year. I would be ok if it just shows the year too, without the month if that helps. Any suggestions please? Thank you

Re: Incorrect Month displayed when selecting full year in single choice filter

tharunkumarRTK — Thu, 11 Apr 2024 10:21:33 GMT

tjordan08
You are using month name column in a date column hiearachy and used 'LAST' as an aggregation, instead create a measure with the below logic

maxMonth = Var MaxMonthNum = max(Fact_Table[First seen].[MonthNo]) return CALCULATE(MAX(Fact_Table[First seen].[Month]), Fact_Table[First seen].[MonthNo] = MaxMonthNum)

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun

Re: Incorrect Month displayed when selecting full year in single choice filter

tjordan08 — Thu, 11 Apr 2024 12:37:35 GMT

THank you Tharun! I just tried but it is still showing September. This is the formula:

maxMonth = Var MaxMonthNum = max('Calendar'[Month]) return CALCULATE(MAX('Calendar'[Month]), 'Calendar'[Month]= MaxMonthNum)

or like this which gave me an error?

maxMonth = Var MaxMonthNum = max('Calendar’[First seen].[Month]) return CALCULATE(MAX('Calendar'[First seen].[Month]), 'Calendar'[First seen].[Month]= MaxMonthNum)

Anything I missed?

Thanks

Re: Incorrect Month displayed when selecting full year in single choice filter

tharunkumarRTK — Thu, 11 Apr 2024 13:39:07 GMT

tjordan08

try this formula

maxMonth = Var MaxMonthNum = max('Calendar'[MonthNo]) return CALCULATE(MAX('Calendar'[Month]), 'Calendar'[MonthNo]= MaxMonthNum)