Forum Discussion

tjordan08's avatar
tjordan08
Regular Visitor
2 years ago
Solved

Incorrect Month displayed when selecting full year in single choice filter

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. Th...
Dax Help
  • tharunkumarRTK's avatar
    tharunkumarRTK
    2 years ago

    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

     

  • tharunkumarRTK's avatar
    tharunkumarRTK
    2 years ago

    tjordan08 

    try this formula

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

tjordan08's avatar
tjordan08
Regular Visitor
2 years ago

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's avatar
tharunkumarRTK
Icon for Super User rankSuper User
2 years ago

tjordan08 

try this formula

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