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
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi  Isgandar_B ,

Here are the steps you can follow：

1. Create measure.

Divide =
var _1=
CALCULATE(SUM('Table2'[Sales - Net+VAT]),FILTER(ALL(Table2),'Table2'[Month]=MAX('Table1'[Month])&&'Table2'[Year]=MAX('Table1'[Year])-1))
return
DIVIDE(
    MAX('Table1'[Sales - Net+VAT]),_1)

2. Result:

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Isgandar_B's avatar
Isgandar_B
Frequent Visitor
4 years ago

Hi Liu Yang, thanks for you reply

I can't test your solution, because I'm just new one in using Power BI, and don't understand DAX as professionals, so i can't just copied you answer because for first i need to understand it step by step, in general i understand it, but FILTER side looks very complicated for me actually, so i can't figure out with this (