Forum Discussion

Fusilier2's avatar
Fusilier2
Icon for Helper V rankHelper V
1 year ago
Solved

Show latest data in visual

I have monthly headcount data by department for our company in a table. I have a KPI visual that shows the headcount for the company as a whole which always shows the headcount for the latest month'...
Need Help
  • pankajnamekar25's avatar
    pankajnamekar25
    1 year ago

    Hello Fusilier2 

    Use this measure

     

    Latest Month Headcount =

    VAR LatestMonth = MAX('Table'[Month])

    RETURN

    CALCULATE(SUM('Table'[Headcount]), 'Table'[Month] = LatestMonth)

     

    Thanks,
     Pankaj Namekar | LinkedIn

    If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

danextian's avatar
danextian
Icon for Super User rankSuper User
1 year ago

Hi Fusilier2 

 

The solution really depends on how your model is set up. Are you using a separate date or calendar table, or are you working directly with the date column in your fact table? If you're using the latter, it also matters whether your month column is a text value or an actual date. If it's text, we can't rely on something like MAX('Table'[Month]), because it’ll just return the last month alphabetically—not the most recent one chronologically.