Business Intelligence with Microsoft Power BI - with Material - Adding and Subtracting Dates Using M Functions

This video tutorial explains how to use M functions in Power BI to add and subtract time periods such as months and years. It covers the use of the 'date add' function for both addition and subtraction, demonstrating the process with examples. The tutorial emphasizes the simplicity of these functions and provides step-by-step guidance for users new to Power BI.

What is the first step in preparing the date table for adding and subtracting days in Power BI?

• Delete all columns in the table

• Duplicate the existing date table

• Rename the table to 'Date Functions'

• Create a new table from scratch

Which function is used to add months to a date in Power BI?

• date change

• date subtract

• date add

• date modify

How can you add five years to a date using the 'date add' function?

• Use 'date add' with the interval set to 'years' and value 5

• Use 'date add' with a negative value

• Use 'date add' with the interval set to 'months' and value 60

• Use 'date add' with the interval set to 'days' and value 1825

What is the method to subtract months from a date using the 'date add' function?

• Use 'date modify' with a negative value

• Use 'date subtract' with a positive value

• Use 'date add' with a negative value

• Use 'date change' with a positive value

If you want to subtract five years from a date, what value should you use in the 'date add' function?

• 5

• -5

• 0

• 10