DP-600 · Question #156
You have a query in Microsoft Power BI Desktop that contains two columns named Order_Date and Shipping_Date. You need to create a column that will calculate the number of days between Order_Date and…
The correct answer is B. Duration.Days. To calculate the number of days between two date columns in Power Query, first subtract the earlier date from the later date to get a duration, then use Duration.Days to extract the day component.
Question
You have a query in Microsoft Power BI Desktop that contains two columns named Order_Date and Shipping_Date. You need to create a column that will calculate the number of days between Order_Date and Shipping_Date for each row. Which Power Query function should you use?
Options
- ADateTime.LocalNow
- BDuration.Days
- CDuration.From
- DDate.AddDays
How the community answered
(34 responses)- A3% (1)
- B94% (32)
- C3% (1)
Why each option
To calculate the number of days between two date columns in Power Query, first subtract the earlier date from the later date to get a duration, then use `Duration.Days` to extract the day component.
`DateTime.LocalNow` returns the current local date and time and is not used for calculating the difference or duration between two existing date columns.
The `Duration.Days` function is used to extract the number of whole days from a `duration` value, which can be obtained by subtracting `Order_Date` from `Shipping_Date` to determine the exact number of days between them.
`Duration.From` converts a number, text, or list into a duration value, but it is not directly used to calculate the difference between two date/datetime columns.
`Date.AddDays` adds a specified number of days to a given date and is used for shifting dates, not for calculating the difference or duration between two dates.
Concept tested: Power Query duration functions
Source: https://learn.microsoft.com/en-us/powerquery-m/duration-days
Topics
Community Discussion
No community discussion yet for this question.