I want to create a charts shows number of inventories by 1 month, 3months, 6months, 1 year, 2years, 3years old.
I curently created a stock age colum by
Solved! Go to Solution.
It seems you need create a new table with group column. Then link them by month columns. Below is the sample file for your reference.
Amount = CALCULATE(DISTINCTCOUNT(Table1[MMD]))+0