Forum Discussion

StuartSmith's avatar
StuartSmith
Icon for Power Participant rankPower Participant
3 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...
Need Help
StuartSmith's avatar
StuartSmith
Icon for Power Participant rankPower Participant
3 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
    Icon for Solution Sage rankSolution Sage
    3 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
      Icon for Power Participant rankPower Participant
      3 years ago

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