Forum Discussion

vengadesh_p's avatar
vengadesh_p
Icon for Helper II rankHelper II
3 years ago
Solved

YOY % changes for Star product

Hi All,   I have data like below table, i want to Create Star Product YOY changes %     Product Sales Is Star? MMM-YY AC 1000   1-Jan-2020 AC 2200   1-Jan-2021 AC 2700 Y 1...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    3 years ago

    Hi, vengadesh_p 

    Please add a new calculated column:

    IsStar = CALCULATE(MAX('Table'[Is Star?]),ALLEXCEPT('Table','Table'[Product]))

     

    Then replace your original field 'Is Star?' with this field  [Is Star] in the slicer to filter the data.

    Result:

    Best Regards,
    Community Support Team _ Eason

     

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi, vengadesh_p 

Please add a new calculated column:

IsStar = CALCULATE(MAX('Table'[Is Star?]),ALLEXCEPT('Table','Table'[Product]))

 

Then replace your original field 'Is Star?' with this field  [Is Star] in the slicer to filter the data.

Result:

Best Regards,
Community Support Team _ Eason