Forum Discussion
DATEDIFF - Exclude weekends and holidays
Hi Community, In this particular example, I do not have a relationship with Calendar Table, this needs to be filtered within the same table. Therefore, I would like to get the DATEDIFF between t...
v-yulgu-msft
That worked like a charm. Only missing one little thing which is, if [Date Presented] is empty, count the days until the end of selected month (Date Demand).
I tried to mix with the logic that I had built but it's behaving the way yours is, when the [Date Presented] is empty, it does not sum until the end of month selected (see img below).
Can you help me achieving that ? Thank you.
Please include a test case with "demand date" in 2018 and "presented date" in 2019.
eg: Demand Date: 15.11.2018 and Presented Date 10.02.2019.