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.
Hi guys,
I'm having a issue with the DAX function DATEADD, I'm trying to compare some metrics week by week, did you guys know how to use function with the interval of week?
Solved! Go to Solution.
Hi.
Please provide some more information of what your data looks like and what you want to achive.
Regarding the function DATEADD: make sure you use correct syntax, e.g.:
New_Date = DATEADD('Sales'[Order Date], 30, DAY)
You might also consider looking into Time Intelligence Functions in Dax:
https://learn.microsoft.com/en-us/dax/time-intelligence-functions-dax
Or combine Calculate (second argument filter context) and Previous Week to calculate a sum or similar previous week:
Sales WoW = CALCULATE(SUM([Sales Amount]), PREVIOUSWEEK(Calendar[Date]))
Hope this helps you on your way.
Kind regards!
Hi.
Please provide some more information of what your data looks like and what you want to achive.
Regarding the function DATEADD: make sure you use correct syntax, e.g.:
New_Date = DATEADD('Sales'[Order Date], 30, DAY)
You might also consider looking into Time Intelligence Functions in Dax:
https://learn.microsoft.com/en-us/dax/time-intelligence-functions-dax
Or combine Calculate (second argument filter context) and Previous Week to calculate a sum or similar previous week:
Sales WoW = CALCULATE(SUM([Sales Amount]), PREVIOUSWEEK(Calendar[Date]))
Hope this helps you on your way.
Kind regards!
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 |
---|---|
97 | |
95 | |
80 | |
77 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |