Stock by group season

[joshua3m]

Learning dax over last few weeks i did hit on the issue which driving me crazy as i can't find workable solution.   

I have dimension: 

-time which can be slice from year to day 

-product season which year and season code ( ie 2023AW or 2023SS )  

Now i'm trying graph YoY view on seasons however be able group this in time. 

3 main groups : 

- current season ( ie 2023 for 2023 , for products from 2022 this will be current season in 2022 but in 2023 stock data it will have different status) 

- previous season ( last year season ) 

- older seasons ( all other products from previous years) 

The issue is to show on graph stock with relevant group information that for products from 2022 in 2022 timeline this will be marked as current season however for any stock produced in 2022 but in stock in 2023 this will be mark as previous season.  

[v-yiruan-msft]

Hi @joshua3m ,

Could you please provide some raw data in your table with Text format and your expected result with backend logic and special examples? It would be helpful to find out the solution. You can refer the following links to share the required info:

How to provide sample data in the Power BI Forum

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

[joshua3m]

is that even possible ?