Forum Discussion

StuartSmith's avatar
StuartSmith
Power Participant
2 years ago

If condition based on slicer selection

I have a slicer connected to a "Date" table with a hirarchy of...

 

Is there a way to create an "IF" measure that can use the slicer selection?  Something like IF(Slicer Selection = "1st Half", "Blah", "Blah Bah")

 

Thanks in advance.

 

5 Replies

  • ChiragGarg2512's avatar
    ChiragGarg2512
    Solution Sage
    2 years ago
    Measure =
    var _date = VALUES(Sales[Delivery Date].[QuarterNo])
    return
    if(_date <= 2, "Blah", "Blah bah")
     
    Create a measure with the above DAX. Change the values in the VALUES function to column name of your table. 

     

    For doing this for 1st and 2nd Half add that particular hierarchy to the DAX, i.e. Sales[Delivery Date].[Half]

     

  • StuartSmith's avatar
    StuartSmith
    Power Participant
    2 years ago

    Quick Idea: 

    I actually have a table that displays the "First" & "Last" date of the slicer selection.  Is there a way too use these dates such as

    IF(DatesBetween(FirstDate, LastDate)=365, "Year",

    IF(DatesBetween(FirstDate, LastDate)=182, "1st Half",  and so on, 

     

    I could manually work out how many days are in Jan, Feb, Mar, Apr, May & Jun for 1st Half, etc. but is there an automatic way such as a function to callculate dates, to cover leap years, etc.

     

    • ChiragGarg2512's avatar
      ChiragGarg2512
      Solution Sage
      2 years ago

      StuartSmith ,

      I am not sure if I will be able to help you to that extent as I am pretty new to Power BI myself. The response that I have given is working perfectly. So do give it a try.

       

      • StuartSmith's avatar
        StuartSmith
        Power Participant
        2 years ago

        Sorry, our posts crossed.  I'll try your solution later and get back to you. Thanks