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

dharmendars007's avatar
dharmendars007
Memorable Member
1 year ago

Hello Anonymous , 

 

You can use the below formula pattern to achieve the result you are looking for..

 

 

If you find this helpful , please mark it as solution and Your Kudos are much appreciated!

 

Thank You

Dharmendar S

LinkedIN 

 

  • TomMartens's avatar
    TomMartens
    Super User
    1 year ago

    Hey dharmendars007 ,

     

    I'm wondering about the difference between your solution and mine because:

    • your solution does not state if it's a measure or a calculated column
    • your solution does not reflect on the different tables, like the Date and Product table

    Regards,

    Tom

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi dharmendars007 
    Its showing below result if i use your dax code 

    But my requirement is different - you can refer my question.

     

    Thanks..!!