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.
I am needing to create a visit window report to show the expected visit windows for visits based on the procedure date.
here is what i have uploaded as an example:
I am trying to have the [Visit window Start] column display to show the [Procedure] date plus 5 days. (see formula bar for what i used).
So for example, the first procedure date is listed as 01-MAR-2020 so the date that should be calculated is 06-MAR-2020. But nothing shows up.
What am I doing incorrectly?
Solved! Go to Solution.
@guanel1 ,
You need a table with continuos date, create a date table and relate them, use this code on your column:
Column = DATEADD(Data[Date], 5, DAY)
@guanel1 , date add need continuous dates , Simply add +5 for days
Visit Window Start = Table3[Procedure] +5
Also, refer: https://www.youtube.com/watch?v=YWo-ZpKM6gU
Thank you, this is works when there is always a date listed in the procedure column. However, if it is blank, what formula should i use to have it give me a blank answer?
@guanel1 ,
You need a table with continuos date, create a date table and relate them, use this code on your column:
Column = DATEADD(Data[Date], 5, DAY)
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 |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |