Forum Discussion
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...
You can create a calculated column or a custom column in Power Query
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"
)