Forum Discussion
Date ADD function, working incorrectly while selecting end of the month dates.
My dateadd function is giving me a problem. Whenever I select a date from 21st Apr'22 - 30th Apr'22 for the sum of sales, date add gives me a sum of values from 21st Mar'22 - 31st Mar'22 (End of the month) Technically, I want to compare sales from
21st Apr'22 - 30th Apr'22 v/s
21st Mar'22 - 30th Mar'22.
- I have a separate date table.
- There are no missing dates in the data, (i.e., all dates have some data)
Kindly help.
1 Reply
- amitchandak
Super User
Shivam_210121 , Date add need continuous dates. So use date as date add
If you want add days
[Date] +10
If you want to add a month or year
Add 15 months
Date as Dateadd - Decoding Date and Calendar 5-5 - Power BI Turning 5 Celebration Series
https://community.powerbi.com/t5/Community-Blog/Date-as-Dateadd-Decoding-Date-and-Calendar-5-5-Power-BI-Turning/ba-p/1187827Date(Year([Date]), Month([Date])+15, Day([date]))
