Implementing Analytics Solutions Using Microsoft Fabric — Question 159

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?

Answer options

• A. DateTime.LocalNow
• B. Duration.Days
• C. Duration.From
• D. Date.AddDays

Correct answer: B

Explanation

The correct choice is B, Duration.Days, as it is specifically designed to calculate the total number of days in a duration between two dates. Options A and D do not perform this specific calculation, while Option C converts a duration but does not calculate the number of days directly.