Microsoft Power BI Desktop DATEDIFF DAX Function (Date and Time) – returns the number of units (unit specified in Interval) between the input two dates

DATEDIFF ( <Date1>, <Date2>, <Interval> )
Date1 – a date in datetime format that represents the start date
Date2 – a date in datetime format that represents the end date
Interval – the unit that will be used to calculate between the two dates it can be SECOND, MINUTE, HOUR, DAY, WEEK, MONTH, QUARTER, YEAR

Leave a Reply

You must be logged in to post a comment.