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 Experts
I am trying to calculate a future date (3 months) from the last appointment date for our users. This will allow us to cancel membership 3 months from the last appointment. My summary table data looks like this
I now need a column which provides the date 3 months from the last attended appointment. I have tried the dateadd function but get an error.
thank you in advance
Solved! Go to Solution.
Hi @Elisa112 ,
@amitchandak nice method! Thank you, for your quick response and the solution provided.
And based on the sample and description you provided, you can also try code as below to create a Calculated column.
FutureDate =
EDATE ( 'Table'[Last appointment date], 3 )
Result is as below.
Best Regards,
Yulia Yan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Elisa112 ,
@amitchandak nice method! Thank you, for your quick response and the solution provided.
And based on the sample and description you provided, you can also try code as below to create a Calculated column.
FutureDate =
EDATE ( 'Table'[Last appointment date], 3 )
Result is as below.
Best Regards,
Yulia Yan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Elisa112 , Create a new column
New Date = date(year([Date]), month([Date])+3, day([Date]) )
@amitchandak thanks for your help as well. I am going to look at your solution to understand this method.
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |