Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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.
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.
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.
Sorry, our posts crossed. I'll try your solution later and get back to you. Thanks
For doing this for 1st and 2nd Half add that particular hierarchy to the DAX, i.e. Sales[Delivery Date].[Half]