Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
vengadesh_p
Helper I
Helper I

YOY % changes for Star product

Hi All,

 

I have data like below table, i want to Create Star Product YOY changes %  

 

ProductSalesIs Star?MMM-YY
AC1000 1-Jan-2020
AC2200 1-Jan-2021
AC2700Y1-Jan-2022
AD100 1-Jan-2020
AD200 1-Jan-2021
AD300N1-Jan-2022
Washing Machine1500 1-Jan-2020
Washing Machine2000 1-Jan-2021
Washing Machine2500Y1-Jan-2022

 

 

Example : i did not filtred star product, so showing result was correct 

1.jpg

when i try to filter "Y" in is_star?  filter, it showing blank value  

2.jpg

expected value is (only AC, Washing Machine is star product)

3.jpg

i want to show YOY % only for is_star = "Y" but, this "Y" was present in 2022 record for this reson it shows blank value

 

Pls help me to resolve this logic

 

 

Sales = sum('Table'[Sales.])


Sales_PY = CALCULATE ( [Sales], DATEADD ( 'Dim_Calendar'[Date], -1, YEAR ) )


%YOY = DIVIDE([Sales]-[Sales_PY],[Sales_PY])

 

 

Thanks

Vengadesh p

 

 

1 ACCEPTED SOLUTION
v-easonf-msft
Community Support
Community Support

Hi, @vengadesh_p 

Please add a new calculated column:

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

veasonfmsft_0-1667548878453.png

 

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

Result:

veasonfmsft_1-1667548906336.png

Best Regards,
Community Support Team _ Eason

 

View solution in original post

1 REPLY 1
v-easonf-msft
Community Support
Community Support

Hi, @vengadesh_p 

Please add a new calculated column:

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

veasonfmsft_0-1667548878453.png

 

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

Result:

veasonfmsft_1-1667548906336.png

Best Regards,
Community Support Team _ Eason

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.