Forum Discussion
Solved
Events in progress with datediff
Hi, For a report on sick days I need to calculate the datediff between startdate and enddate. If the enddate is 1-1-2100 the enddate is today. While this is no problem I cant get it to work if I ...
RobBeijers312 , refer
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM
Power BI- DAX: Get all dates between the Start and End date: https://youtu.be/y7AL_quvq5w
If the enddate is 1-1-2100Don't do that. Leave the end date BLANK in these cases. Otherwise your calendar is ballooning unnecessarily.
Consider using CALENDAR and COUNTROWS(INTERSECT()) as an alternative approach.