Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello, I'd like to filter the start-end date of employee leave record based on a selected date. I'm using the following DAX but it seems to be not working. Please help.
SelectedDate = CALCULATE(SUM(Leave[ContactID]), FILTER(Leave, SELECTEDVALUE('Calendar'[Date]) <= ALL(Leave[LeaveFrom]) && SELECTEDVALUE('Calendar'[Date]) >= ALL(Leave[LeaveTo]) ))
Hi @Anonymous ,
To update your measure as below to have try. If it doesn't meet your requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
SelectedDate = CALCULATE ( SUM ( Leave[ContactID] ), FILTER ( Leave, SELECTEDVALUE ( 'Calendar'[Date] ) <= Leave[LeaveFrom] && SELECTEDVALUE ( 'Calendar'[Date] ) >= Leave[LeaveTo] ) )
Thank you so much for replying.
I have one table which contains employee leave data, typically it contains employee name, leave start and leave end date. I have two other tables, contains project and user's timesheet information.
What I wanted is to filter the user's timesheet and its leave information based on the date selection from the Calander table.
For example: if a user is going on leave from 4th Mar - 20th Mar, and If I select 15th Mar from the calendar, I should be able to see leave information of that particular user on that selected date along with all the planned task he has been assigned to that date.
Here is the link to the power bi file: https://1drv.ms/u/s!AkX-WgOcYFxrh0ylE2BQtYvcKfsr
and see Page 1.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
93 | |
86 | |
80 | |
69 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |