Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Year wise calculation

Hi Community..!! Please refer the above image, Product-Backend is coming from Product table Year is coming from Date table  I want to display in column Market Growth YOY - value of 2022 wil...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi, Anonymous 

    Thanks for TomMartens and dharmendars007 reply. If you have not solve the problem. You can try using the following measure.

    My Model:

    Market Growth YOY = 
CALCULATE (
    SUMX ( 'Product', 'Product'[Value] ),
    ALLEXCEPT ( 'Product', 'Date'[Year] )
)

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi TomMartens 

Its showing below result if i use your dax code.

TomMartens's avatar
TomMartens
Super User
1 year ago

Hey Anonymous ,

 

you can try this:

 

Market Growth YOY = 
CALCULATE(
SUM('<the table namw>'[Value]),
ALL('Product'[Product-Backend]),
'Product'[Product-Backend] in { "Aimovig / ..." , "Ajovy / ..." }
)

 

Make sure that you provide the 2 items from the Product-Backend column shown in your image.

 

Regards,

Tom