Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Create table that filters another table by multiple months

I need a new table that brings over some columns from my initial table but filters it for a few months.   I got it to work with only 1 month like this:   Current Year Table = CALCULATETABLE(SUMM...
Need Help
  • Dangar332's avatar
    Dangar332
    2 years ago

    Hi, Anonymous 

    try below it might work

    Current Year Table = 
CALCULATETABLE(SUMMARIZE(
'Survey Data',
'Survey Data'[ResponseId],
'Survey Data'[Combined NPS],
'Survey Data'[CES Promoters],
'Survey Data'[CES Detractors],
'Survey Data'[CES Total],
'Survey Data'[EndDate]),
MONTH('Survey Data'[EndDate])=1 , MONTH('Survey Data'[EndDate])=2)

    you can use or( || ) if you needed instead of  , (and(&))

Dangar332's avatar
Dangar332
Resident Rockstar
2 years ago

Hi, Anonymous 

try below it might work

Current Year Table = 
CALCULATETABLE(SUMMARIZE(
'Survey Data',
'Survey Data'[ResponseId],
'Survey Data'[Combined NPS],
'Survey Data'[CES Promoters],
'Survey Data'[CES Detractors],
'Survey Data'[CES Total],
'Survey Data'[EndDate]),
MONTH('Survey Data'[EndDate])=1 , MONTH('Survey Data'[EndDate])=2)

you can use or( || ) if you needed instead of  , (and(&))

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Using || in place of OR worked, thank you.