The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
(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