Just a quick tip that you might not be aware of in the Power Query Editor.

If you select two columns in the view and on the Add Column tab, select the Date button – you can select to Subtract Days

This will give you the number of days between the dates in the selected columns

Use the formula bar to rename the new column by modifying the step

Hope this can help you too –

Let’s block ads! (Why?)

Erik Svensen – Blog about Power BI, Power Apps, Power Query