Forum Discussion

DonRSA's avatar
DonRSA
Frequent Visitor
2 years ago

Prior Year

Hi Guys, I have a problem with my Prior year measure when i use it to a calculated table,it's returning blanks on my figure column. See below measure: PriorYearFigure = VAR SelectedYear = SELEC...
Tutorial Requests
HotChilli's avatar
HotChilli
Community Champion
2 years ago

You can create a calculated column or a custom column in Power Query

  • DonRSA's avatar
    DonRSA
    Frequent Visitor
    2 years ago

    Hi i've never done that, see my measure , how will i do it?

    Prior Year FigureMeas =
    CALCULATE(
    SUM('KPI MTM Last'[Figure]),
    FILTER(
    ALL('KPI MTM Last'[Fiscal Year]),
    'KPI MTM Last'[Fiscal Year] = SELECTEDVALUE('KPI MTM Last'[Fiscal Year]) - 1
    ),
    'KPI MTM'[Indicator] = "Actuals"
    )