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.
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.
@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]))
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |