Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
User | Count |
---|---|
127 | |
72 | |
70 | |
58 | |
53 |
User | Count |
---|---|
192 | |
96 | |
67 | |
64 | |
54 |