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 last year 2022 and change every time the year changes.

 

The data for this is a measure [Accidents per 100k Miles] and Date is ''Datamart AccidentSummary'[Merged FC]

2 Replies

  • 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.