Forum Discussion

Isgandar_B's avatar
Isgandar_B
Frequent Visitor
4 years ago

Power BI YoY different tables

Hi dear community, I have a question related to YoY. So, I have 2 tables, for example one with CY 2022 by month (Jan'22, Feb'22 and etc.) and another one CY 2021 (Jan'21, Feb'21 and etc.) they ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Isgandar_B , Both tables can join with  a common date table and and you can get current year from one and last year from second

 

example

 

current  = SUM(Sales[Sales Amount])

 

past

 

Year behind Sales = CALCULATE(SUM(Sales1[Sales Amount]),dateadd('Date'[Date],-1,Year))
Year behind Sales = CALCULATE(SUM(Sales1[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date]))

  • Isgandar_B's avatar
    Isgandar_B
    Frequent Visitor
    4 years ago

    Hi amitchandak, 
    Thanks for quick reply, but as i understand so i need another table with dates like calendar to can link them over date, because in one file month only from 2021 and in another one it is only 2022