Forum Discussion
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 will sum i.e 13474 + 3381 = 16855 and value of 2023 will sum i.e 12698 + 8659 = 21357
and result will diplay like this
2022 16855
2022 16855
2023 21357
2023 21357
Could you please help me to resolve this.
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 TeamIf 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
7 Replies
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 TeamIf 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
Hey Anonymous ,
you have to create a measure, this will do the trick:
Market Growth YOY = CALCULATE( SUM('<the table namw>'[Value]), ALL('Product'[Product-Backend]) )Hopefully, this creates what you are looking for.
If not, create a pbix file that contains sample data, but still reflects your semantic model (tables, relationships, calculated columns, and measures), upload the pbix to OneDrive, Google Drive, or dropbox and share the link. If you are using a spreadsheet to create the sample data, instead of the manual input method, share the spreadsheet as well.
Regards,
Tom
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
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
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
Hi dharmendars007
Its showing below result if i use your dax codeBut my requirement is different - you can refer my question.
Thanks..!!
