Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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...
Need Help
  • Seward12533's avatar
    Seward12533
    8 years ago

    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!

Seward12533's avatar
Seward12533
Icon for Solution Sage rankSolution Sage
8 years ago

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.