Forum Discussion

amandabus21's avatar
amandabus21
Icon for Helper V rankHelper V
3 years ago

Years past data

How can I get the total of a previous year on an automated basis?    Im looking to have  report that is always displayin gall of last years data, on an automated basis. For example show all of las...
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi amandabus21 

try like:

Measure =
CALCULATE(
    [Accidents per 100k Miles],
    YEAR('Datamart AccidentSummary'[Merged FC]) = YEAR( MAX('Datamart AccidentSummary'[Merged FC]))-1
)
amandabus21's avatar
amandabus21
Icon for Helper V rankHelper V
3 years ago

This givs me a total of all not the specific year. I need a display of this year and last year.