Forum Discussion
Aligning different dates as M1, M2 etc
- 4 months ago
For this kind of cohort/launch-aligned chart, the cleanest approach is a calculated column on the fact table that turns each row's date into "months since launch" for that Country and Product. Then put that column on the X axis, Country in the legend, and Sales on Y, with your Attribute as a slicer.
Months Since Launch = VAR LaunchDate = CALCULATE ( MIN ( 'Sales'[Date] ), ALLEXCEPT ( 'Sales', 'Sales'[Country], 'Sales'[Product] ) ) RETURN ( YEAR ( 'Sales'[Date] ) - YEAR ( LaunchDate ) ) * 12 + ( MONTH ( 'Sales'[Date] ) - MONTH ( LaunchDate ) ) + 1Replace 'Sales' with your table name. The launch month shows as 1, the next month as 2, and so on, no Power Query loops needed. If you want a clean "M1, M2, ..." label, add another column: M Label = "M" & 'Sales'[Months Since Launch] and use that on the axis.
If this works for you, kindly mark it as the solution and give a thumbs up.
Best,
Shai Karmani
You may want to explore the recently announced unmaterialized calculated columns feature. This will give you the flexibility to do dynamic-ish bucketing.