Forum Discussion
Duration.days returning false values (Power Query)
Hello Everyone, I am using duration.days to calculate the duration between two dates. But the result is sometimes right and sometimes wrong. For example between 28/04/2020 and 04/05/2020 it sh...
Go To >> Power Query >> Select first date then Select subtract date column >> Add column tab >> from Date & time >> Date drop down >> click subtract day >> you got your answer correct.
>>first date is exluding it is not including.