Show matrix table column with last year's data sum

[Anonymous]

Hello all, 

Please can I ask for your help?

I have a matrix table with slicer which allows a user to determine within month/ year to show data.

I have a table "FTE" with a column also called FTE. The image above shows a matrix with column called "Forecast" which is a sum of the FTE column from within the FTE table. The FTE table shows entries for 2022 to 2024.

I need to show a column in the matrix called "Actual" which shows the sum of the FTE column for the previous year e.g. for October 2022.

The Measure I've tried to use is:

Actual =

CALCULATE(

    SUM(FTE[FTE]),

    FTE[WeekCommencingYear] = SELECTEDVALUE(DateTable[ReportingYear]) -1

    && FTE[WeekCommencingMonth] = SELECTEDVALUE(DateTable[ReportingMonth]) )

but the column doesn't show any values.

I realise this is due to the Slicer which is set to show values for October and November 2023 - therefore it is omitting any values for October and November 2022, which is what should show in the Actual column.

How can I create a measure which looks at the FTE table, and sums all FTE column values filtered to the month of the previous year?

Many thanks for your help. 

[lbendlin]

You use a disconnected table to feed your slicer.

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...