nerdexam
MicrosoftMicrosoft

DP-600 · Question #156

DP-600 Question #156: Real Exam Question with Answer & Explanation

Sign in or unlock DP-600 to reveal the answer and full explanation for question #156. The question stem and answer options stay visible for context.

Submitted by klara.se· Apr 18, 2026Prepare data

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

Unlock DP-600 to see the answer

You've previewed enough free DP-600 questions. Unlock DP-600 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Power Query M#Date calculations#Duration functions#Calculated columns
Full DP-600 PracticeBrowse All DP-600 Questions