MDFT Academy Quizzes

Calculate Days Between Order and Shipping Dates

You have a query in Microsoft Power BI Desktop that contains two columns named ORDERDATE and SHIPPINGDATE. You need to create a new column that will calculate the number of days between ORDERDATE and SHIPPINGDATE for each row.

Which Power Query function should you use?

Choose the correct answer from the options below.

Explanations for each answer:

Date.AddDays is incorrect. Date.AddDays adds a specified number of days to a date value. It does not calculate the difference between two dates.
Duration.Days is correct.
DateTime.LocalNow is incorrect. DateTime.LocalNow returns the current date and time. It is used to get the current timestamp, not to calculate date differences.
Duration.From is incorrect. Duration.From converts a text value like '2.5:00:00' into a duration type. While it can be used to create durations, it cannot directly calculate the difference between two dates.

Exam Preparation Quiz

Calculate Days Between Order and Shipping Dates