Forum Discussion

CleliaComes's avatar
CleliaComes
Icon for Helper I rankHelper I
5 years ago
Solved

Matrix with figures this year / last year

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 possibl...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    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.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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.