Date ADD function, working incorrectly while selecting end of the month dates.

[Shivam_210121]

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.

[amitchandak]

@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...

Date(Year([Date]), Month([Date])+15, Day([date]))