Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a calculated column in my data set (DataTable2019 Test) which is looking at a date column (History Date) subtracting one year from the date and then returning a custom formatted date. For full context here I'm trying to show the Jan 1st dates as the year end (YE) count for that given year.
This is the formula below:
Solved! Go to Solution.
I'm guessing your date table doesn't have dates prior to 2020. DATEADD doesn't work by adding or subtracting from a given date, it returns a result from your date table shifted by the interval you've specified. If no dates exist prior to 2020, you won't get a result. Take a look at the DATEADD documentation for more info.
DATEADD function (DAX) - DAX | Microsoft Docs
I had the same issue with DATEADD and adding multiple years to a certain column. EDATE works perfect in this case EDATE(<date-field, ,nr of months>)
I'm guessing your date table doesn't have dates prior to 2020. DATEADD doesn't work by adding or subtracting from a given date, it returns a result from your date table shifted by the interval you've specified. If no dates exist prior to 2020, you won't get a result. Take a look at the DATEADD documentation for more info.
DATEADD function (DAX) - DAX | Microsoft Docs
That makes sense, thank you.
is there another function that can just subtract 1 year from the date in the history table?
so for the 2020 dates in my table, they would return a result of "YE 2019".
Take a look at the EDATE function