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.
Hola expertos,
¿Puede alguien ser capaz de guiarme cómo solucionar este problema, por favor?
Mi código DAX es este:
Hi @IdoiaPerez
You can refer to the following links:
Solved: Dateadd - Microsoft Power BI Community
Solved: DATEADD DAX FUNCTION - Microsoft Power BI Community
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hi @IdoiaPerez
DATEADD is a Time Intelligence function. Always reference the date column from a qualified Date Table in Time Intelligence functions.
@IdoiaPerez , dateadd need continous dates, so it can error if they are not
to add days, simple add to date
[Date] +20
for year and month use date
add 10 month
date(year([Date]) , month([Date])+10, day([Date]) )
Dateadd and its Alternate: https://www.youtube.com/watch?v=9qiRivlBv8w&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=66
Date as Dateadd
https://community.powerbi.com/t5/Community-Blog/Date-as-Dateadd-Decoding-Date-and-Calendar-5-5-Power...
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |