Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi,
if this Column formula works "3 months date = DATEADD('JobOrder (2)'[Maximum Date].[Date],-3,MONTH)" why wouldn't this Column formula work " 4 months date = DATEADD('JobOrder (2)'[Maximum Date].[Date],-4,MONTH)"?
thanks
Tony
Solved! Go to Solution.
Hi @TonyR1869 ,
Dateadd() function returns a table that contains a column of dates, shifted either forward or backward in time by the specified number of intervals from the dates in the current context. Please note that:
If the dates in the current context do not form a contiguous interval, the function returns an error.
The result table includes only dates that exist in the dates column.
For example, the date column like this, when using dateadd(), it will just return the follwing result because there is no date about 2019 exist in the already existing tables so that these columns will return blank by this formula.
If there is a date related 2019 context exists, it will return normal results by this formula:
For more details about Dateadd() function, please refer the microsoft document: DATEADD
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @TonyR1869 ,
Dateadd() function returns a table that contains a column of dates, shifted either forward or backward in time by the specified number of intervals from the dates in the current context. Please note that:
If the dates in the current context do not form a contiguous interval, the function returns an error.
The result table includes only dates that exist in the dates column.
For example, the date column like this, when using dateadd(), it will just return the follwing result because there is no date about 2019 exist in the already existing tables so that these columns will return blank by this formula.
If there is a date related 2019 context exists, it will return normal results by this formula:
For more details about Dateadd() function, please refer the microsoft document: DATEADD
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
This basically moving your date 3 or 4 months back. In this case that is max date. If 3 is working for purpose 4 will also
thats what I thought as well, but the 4 months back returns blank!
Hi @TonyR1869
Can you provide the error message or explain the issue and scenario?
It just returns blank??? I'm trying to move Max Date back 3 or 4 months
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
218 | |
86 | |
64 | |
63 | |
60 |