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.
Hi all,
Im looking to do a calculation that will provide me with future 'no later than' dates for a survey.
I have a project start date (01.01.20) and project end date (31.12.20) and want a calculation that will provide the half way date (06.20) and another one to calculate one month after the project end date.
I'm presuming this is pretty easy to do but cant find anything online (although likely its my search terminology)
Thanks in advance 🙂
Solved! Go to Solution.
@eilidh3 , Both as new columns
mid date = [start_date]+ quotient(datediff([start_date],[end_date],day),2)
one month after date = date(year([end_date]),month([end_date])+1,day([end_date]))
@eilidh3 , Both as new columns
mid date = [start_date]+ quotient(datediff([start_date],[end_date],day),2)
one month after date = date(year([end_date]),month([end_date])+1,day([end_date]))
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
148 | |
116 | |
104 | |
89 | |
65 |