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.
