Forum Discussion
Overdue date calculation date
(New to PBI) In Transform Data Page, how do I insert a column that shows dates overdue as of today's date. Site Visit ECD is the Due Date and when Site Visit ACD is blank
Site Visit Duedate Actual Date of Site Visit
9/3/2024 9/3/2024
9/23/2024 9/25/2024
9/18/2024 null
9/16/2024 null
I wanted to add a column that show as of today, records that have not had an actual visit
Hi SHER101
Based on your description, what is your record like, is the Actual Date of Site Visit your output? what is the logic of it, can you provide more sample data ?
Best Regards!
Yolo Zhu