Mastering the EDATE dax in Power BI ( Step by Step)

EDATE function in DAX | EDATE function in Power BI | Dax date functions | Edate formula | Edate ka formula

This video will help you understand the EDATE DAX function in details. I have tried to use different scenarios of EDATE function in Power bi to let you know how this function can be useful.

This function can be applied to calculated column, calculated table, measure and visual calculations.

The Syntax of EDATE function is :-

EDATE ( STARTMONTH, MONTHS)

STARTMONTH:- The column reference or the exact date as the first parameter with respect to which you want to get the resulting new date. The STARTMONTH should be in the datetime format or text format.

MONTHS:- The column reference containing months after or before the start month or static number of months to be entered.

EDATE function :- EDATE function returns a date on the same day of the month, n months before or after a start date. It is used to calculate expiration dates, maturity dates, and other due dates derived from a start date.

This function is a part of Date and time functions category of DAX functions.

If you like this video and want to learn Power BI and DAX, then you can check out our channel:-

#powerbi #dataanalytics #powerbi_training #powerbipro #powerbitraining #learnpowerbi #businessintelligence #daxfunctions #dataanalysis