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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors