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
I have the below dates in a table, what i want to do is create the Review check column. If the Scheduled review is 30 days or less than the actual review I want to return Not Scheduled. If it is over 30 days after the actual review I want to return the scheduled review date.
Actual Review | Scheduled Review | Review Check |
01/09/2019 | 15/09/2019 | Not Scheduled |
01/09/2019 | 30/10/2019 | 30/10/2019 |
01/09/2019 | 05/09/2019 | Not Scheduled |
01/09/2019 | 01/11/2019 | 01/11/2019 |
thanks
Solved! Go to Solution.
So that means that the scheduled review column is of type text and not date. Is it the same for the actual review columns? IF so,
Review Check = IF ( Table1[scheduled review] = "To be scheduled", "Not scheduled", IF ( DATEVALUE ( Table1[scheduled review] ) - DATEVALUE ( Table1[actual review] ) <= 30, "Not scheduled", Table1[scheduled review] ) )
Please mark the question solved when done and consider giving kudos if posts are helpful.
Cheers
Hi @WJ876400
Review Check = IF ( Table1[scheduled review] - Table1[actual review] <= 30, "Not scheduled", FORMAT ( Table1[scheduled review], "DD/MM/YYYY" ) )
Please mark the question solved when done and consider giving kudos if posts are helpful.
Cheers
Sorry @AlB I missed that the table looks like this as there is not always a date in the scheculed column
Actual Review | Scheduled Review | Review Check |
01/09/2019 | 15/09/2019 | Not Scheduled |
01/09/2019 | 30/10/2019 | 30/10/2019 |
01/09/2019 | 05/09/2019 | Not Scheduled |
01/09/2019 | 01/11/2019 | 01/11/2019 |
01/09/2019 | To be scheduled | Not Scheduled |
01/09/2019 | To be scheduled | Not Scheduled |
So that means that the scheduled review column is of type text and not date. Is it the same for the actual review columns? IF so,
Review Check = IF ( Table1[scheduled review] = "To be scheduled", "Not scheduled", IF ( DATEVALUE ( Table1[scheduled review] ) - DATEVALUE ( Table1[actual review] ) <= 30, "Not scheduled", Table1[scheduled review] ) )
Please mark the question solved when done and consider giving kudos if posts are helpful.
Cheers
Hi @AlB
Sorry I haven't given you the full information - Scheduled review is TEXT and the actual review is Date.
The scheduled review date is from another measure that outputs the date or To be scheduled
thanks
Hi @AlB
thanks for the quick response. I get the below error so it looks like I need to format the dates?
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |