Forum Discussion
Fusilier2
Helper V
Helper VShow 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'...
Hello Fusilier2
Use this measure
Latest Month Headcount =
VAR LatestMonth = MAX('Table'[Month])
RETURN
CALCULATE(SUM('Table'[Headcount]), 'Table'[Month] = LatestMonth)
Thanks,
Pankaj Namekar | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
pankajnamekar25
Super User
Super UserHello 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.