Forum Discussion
Simple aggregation
So I have a very basic table Date Category 1/1/18 A 1/1/18 B 1/1/18 A 1/2/18 A 1/2/18 D 2/4/18 E and so on I can get the count of cetegory by Year Month rolled up, but I wan...
I'd stil add the date table. Opens up all kinds of options. you can do this dynamically
Using Create Table form the modeling window
DateDim = CALENDAR(MIN(table[date]),MAX(table(date))
Link to your date column and Voila!
No there is no data tbale in teh model, it is very flat csv file, all the data in a singel sheet.
Seward12533
Solution Sage
Solution SageI'd stil add the date table. Opens up all kinds of options. you can do this dynamically
Using Create Table form the modeling window
DateDim = CALENDAR(MIN(table[date]),MAX(table(date))
Link to your date column and Voila!