Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
(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