Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
(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
Please provide the data as table here and for this data what is the result?
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