Overdue date calculation date

Question

(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

omid_motamedise · Answer

Please provide the data as table here and for this data what is the result?

sher101 · Answer

Site Visit Duedate Actual Date of Site Visit&nbsp;9/3/2024&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;9/3/20249/23/2024&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9/25/20249/18/2024&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;null9/16/2024&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; null&nbsp;&nbsp;I wanted to add a column that show as of today, records that have not had an actual visit

anonymous · Answer

Hi&nbsp;SHER101&nbsp;
Based on your description, what is your record like, is the&nbsp;Actual Date of Site Visit&nbsp; your output? what is the logic of it, can you provide more sample data ?
&nbsp;
Best Regards!
Yolo Zhu
&nbsp;
&nbsp;

Forum Discussion

Overdue date calculation date

3 Replies

Related content

Calculate days overdue based on date column

Calculating days overdue based on selected date

Find overdue dates this month

Calculate Overdue Between Dates

Date Overdue