Forum Discussion

iioannou's avatar
iioannou
Helper I
8 years ago
Solved

DAX - target specific columns with value

I have this code below   Budget Accommodation = SWITCH('Daily Revenue'[RevenueDateM], "January", SUM('Budget Accommodation'[January]), "February", SUM('Budget Accommodation'[February]), "March",...
Need Help
  • iioannou's avatar
    iioannou
    8 years ago

    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])
    )

iioannou's avatar
iioannou
Helper I
8 years ago

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

iioannou's avatar
iioannou
Helper I
8 years ago

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])
)