Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
How I can calculate in a new column an Estimated Time of Arrival (ETA) addinga number of days from other column with a date. I saw that one solution is to create a new table with the number of days to add, but I'm not understanding how to create the relationship.
I appreciate your support!
Solved! Go to Solution.
DATEADD() function requires the result date exists in the same column. I suggest you directly add days on date. It can be done via either DAX or Power Query approach.
Regards,
DATEADD() function requires the result date exists in the same column. I suggest you directly add days on date. It can be done via either DAX or Power Query approach.
Regards,
Hi! I have this kind og scenario but I need to exclude weekends in the calculation.
This solved my problem with the mismatch of days between SharePoint list and PowerBI query.
Thanks!
Thank you
Thanksss!!!
I saved me into another problem
Facing same issue but im having noOfDays column in another table then how should i add it to a date in different table ,Here ur using 1 which is constant what if i wanna take this days dynamically from another table???? Plz helpp Thanx in advance
I am have the same problem. Any response?
Did you get a solution to this by any chance
Tough to help without more information, but I think you are looking for DATEADD:
https://msdn.microsoft.com/en-us/library/ee634905.aspx
Please see:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |