Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to use the DATEADD function. Ideally, I'd like to add 12 months, and subtract one day, so if anyone can help me with the formula for this, I'd really appreciate it.
For now, let's consider the formula MOU_EndDate = DATEADD(Analytics[MOU_Date],12,MONTH). Why does this work for some cells and not others (blanks) as shown? Both columns are set to Date format. ANy help is greatly appreciated. Thanks!
Solved! Go to Solution.
I don't know why this wasn't working, but I figured out another way to do what I wanted: MOU_EndDate = EOMONTH(Analytics[MOU_Date],11) - and it works for all cells.
I think dateadd works only if there is a date in a date table. Try below
Column = datecheck[Column1]+365..
I don't know why this wasn't working, but I figured out another way to do what I wanted: MOU_EndDate = EOMONTH(Analytics[MOU_Date],11) - and it works for all cells.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |