Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
106 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |