The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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]