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", 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 ?

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

3 Replies

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