Forum Discussion
DAX - target specific columns with value
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])
)
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
Thank you - I managed to find a solution. Will close this thread.
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])
)