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.
The power query formula shown below is given me the error shown below.
A sample of the data where Completed Paste Due ❤️ Days is displaying "error" is shown below as well.
Task Due Date and Task Finished Date are both of type date.
Any idea how to fix this error?
if [Completed Past Due]=1 and ([Task Finished Date]-[Task Due Date])>=0 and ([Task Finished Date]-[Task Due Date])<3 then 1 else 0
Thank you.
Solved! Go to Solution.
Hi,
This should work
Hope this helps.
Hi,
This should work
Hope this helps.
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 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |