I have the need to show the latest figure in a dataset within a card visual. This data is added to each month so i have a need to only show the latest month. I've currently got this measure but it doesnt seem to be working. Any help?
last =
var last_value = MAX('Civils CRE ATW New'[# Staff])
RETURN
MAXX(
FILTER(ALL('Civils CRE ATW New'),'Civils CRE ATW New'[# Staff] = last_value),
'Civils CRE ATW New'[# Staff]
)
I found the below solution to work for my problem.
Latest = LASTNONBLANKVALUE('table'[column], SUM('table'[column]))