Matrix with figures this year / last year

[CleliaComes]

Hi,

I want to show the results of 2020 and the budget figures of 2021 in the same matrix.

Saldi resultaat = table with data of 2020 - 2021 

Gebudgeteerd = table with data of 2021

Is it possible to use a formular to filter on table 'Saldi resultaat' to show only the figures of 2020?

Now the matrix shows the figures for 2020 + 3 months of 2021. 

Formular table saldi resultaat = 

Saldi resultaat = 'GL PL'[Credit]-'GL PL'[Debet]

Thanks in advance,

Kind regards,

Clélia

[CleliaComes]

Thanks a lot! It works. 🙂 

Kr

Clélia

[amitchandak · Accepted solution]

@CleliaComes , You can use time intellignece , select 2021 in slicer

YTD Budget= CALCULATE(SUM(Budget[Budget Amount]),DATESYTD('Date'[Date],"12/31"))
Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.