Incorrect Month displayed when selecting full year in single choice filter

[tjordan08]

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

 

[tharunkumarRTK · Accepted solution]

@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

[tjordan08]

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

[tharunkumarRTK · Accepted solution]

@tjordan08 

try this formula

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

[tharunkumarRTK · Accepted solution]

@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