DAX - target specific columns with value

[iioannou]

I have this code below

Budget Accommodation = SWITCH('Daily Revenue'[RevenueDateM],
"January", SUM('Budget Accommodation'[January]),
"February", SUM('Budget Accommodation'[February]),
"March", SUM('Budget Accommodation'[March]),
"April", SUM('Budget Accommodation'[April]),
"May", SUM('Budget Accommodation'[May]),
"June", SUM('Budget Accommodation'[June]),
"July", SUM('Budget Accommodation'[July]),
"August", SUM('Budget Accommodation'[August]),
"September", SUM('Budget Accommodation'[September]),
"October", SUM('Budget Accommodation'[October]),
"November", SUM('Budget Accommodation'[November]),
"December", SUM('Budget Accommodation'[December])
)

but I want this to apply only on rows that have a specific column with value e.g 100102 ? is there a way I can achieve this ?

[v-yulgu-msft]

Hi @iioannou,

I am not very clear about your requirement. Would you please share sample data and show us your desired output? 

How to Get Your Question Answered Quickly

Regards,

Yuliana Gu

[iioannou]

Thank you - I managed to find a solution. Will close this thread.

[iioannou · Accepted solution]

For reference this is what I was after

Budget Meal Terms = SWITCH('Daily Revenue'[RevenueDateM],
"January", SUM('Budget Meal Terms'[January]),
"February", SUM('Budget Meal Terms'[February]),
"March", SUM('Budget Meal Terms'[March]),
"April", CALCULATE(SUM('Budget Meal Terms'[April]), FILTER('Daily Revenue', 'Daily Revenue'[Code] = "10201")),
"May", SUM('Budget Meal Terms'[May]),
"June", SUM('Budget Meal Terms'[June]),
"July", SUM('Budget Meal Terms'[July]),
"August", SUM('Budget Meal Terms'[August]),
"September", SUM('Budget Meal Terms'[September]),
"October", SUM('Budget Meal Terms'[October]),
"November", SUM('Budget Meal Terms'[November]),
"December", SUM('Budget Meal Terms'[December])
)