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] ) )
Hi,
How exactly is the source data arranged? Share that in a format that can be pasted in an MS Excel file.