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 want the sigle row of just previous month dynamically. Meaning if I'm in Aug, it shows only July data
Something like
Year Month -------- Count
07-2018 ---------- 50
Thanks in advance
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!
7 Replies
Try this measure if you want to apply filters and have it show the last month of the filtered months.
Last Month Measure = CALCUALTE([MEASURE],FILTER(Date,date[Date]=MAX(date[Date]))
This one if you want the last month regardless of any filterss (for date) applied.
Last Month Measure = CALCUALTE([MEASURE],ALL(Date]),FILTER(ALL(Date),date[Date]=MAX(date[Date])
You can then create table and drag in your YEAR-Month form the DATE Table and then add your Last Month Measure.