Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Using IF Function based on filtered Month selection

Hello, I am looking for some urgent help in fixing a DAX measure please. 

I am essentially trying to create a measure using the IF Function based on what Month has been filtered on in the dashbaord, eg) if Jan is selected i want one formula to be used and if September is selected i want a different formula to be used. 

I have the formulas for a False & True result from the if function ready but the trouble I am having is building the If Function formula and linking that to the Month table in the query, here is what I have so far when practicing with January, note I also tried "Jan"; 

= IF((SUM(Months[Month]) = {"1"})     

The Month table in the query is laid out like the following just for reference:

Month   Index
Jan         1 
Feb         2
etc etc 


I am pretty new to this so any help would be greatly appreciated thank you so much in advance!! 🙂 




2 Replies

  • dedelman_clng's avatar
    dedelman_clng
    Community Champion
    5 years ago

    Hi Anonymous - use SELECTEDVALUE on the month.

     

    Measure = 
SWITCH( SELECTEDVALUE(Month[Month]),
"Jan", FormulaA,
"Feb", FormulaB,
...
)

     

    SWITCH also helps you by not having imbedded IF statements.  Here is a good site to help you with the language: https://dax.guide/ . It can give you more info on the functions mentioned here.

     

    Hope this helps

    David

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Great thank you so much!!

       

      Just one more follow on query please..

      I'm playing around with the formula as i'm trying to get the first half of the year to have one result and the second half of the year to have a different result, i've tried this but it doesn't work:

       

      MONTH TEST = SWITCH( SELECTEDVALUE(Months[Month]), "Jan, Feb, Mar, Apr, May, June", 1, "Jul, Aug, Sep, Oct, Nov, Dec", 2)
       
      Do you know how to do this?
      Many thanks