Forum Discussion
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...
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.