Forum Discussion
sabeensp
Helper IV
Helper IVLast 12 Month Extract
Hello, I'm new to PBI. I have a table with many columns including Year and Month. I need to SUMMARIZE table into another table with only last 12 months data. We do not have DATE Dimmension in...
Perhaps something like:
Table 1 = VAR __year = MAX('Table'[Year]) VAR __yearPrev = __year - 1 VAR __month = MAXX(FILTER('Table',[Year]=__year),[Month]) VAR __table = FILTER('Table',[Year] = __year || ([Year] = __yearPrev && [Month] > __month)) RETURN SUMMARIZE(__table,[Year],[Month],"My Column",SUM([Value]))Also, I feel that this link might come in handy for you:
Greg_Deckler
Community Champion
Community ChampionPerhaps something like:
Table 1 =
VAR __year = MAX('Table'[Year])
VAR __yearPrev = __year - 1
VAR __month = MAXX(FILTER('Table',[Year]=__year),[Month])
VAR __table = FILTER('Table',[Year] = __year || ([Year] = __yearPrev && [Month] > __month))
RETURN
SUMMARIZE(__table,[Year],[Month],"My Column",SUM([Value]))
Also, I feel that this link might come in handy for you:
sabeenspHelper IV
Helper IVThanks
VAR __month = MAXX(FILTER('Table',[Year]=__year),[Month]) -- This row is not letting meselect Month from the table
- Greg_Deckler
Make sure to replace 'Table' with the name of your actual table. Does your table have a Month column? I have this working in a model, you want "Table 1" in the attached file. This builds a table based upon the "Calendar" table.
- sabeensp
Thanks, I missed typed your MAXX with MAX,