Forum Discussion
Solved
Days between two dates. Kinda....
Hello all. I have a leave calendar where the customer is asking for a report that returns the number of days from. a date range. Here is a scenario Person A is on leave 11/01/2023 - 11/15/2023. ...
Additionally, if your data is in the traditional format with from/to dates like this:
You can transform it into a more easy to use format with a calculated table using DAX:
Leave Expanded = GENERATE( LeaveTable , CALENDAR( LeaveTable[From Date] , LeaveTable[To Date] ) )
Pretty easy with data in the following format:
Create a calendar table and set up a relationship. Add a slicer using the calendar table.