Power BI Count number of Days cell is blank

  Kiến thức lập trình

I have a Power Bi report and I need to calculate the number of days a cell has been blank based of the delivery created on date. I have three columns in my data: delivery #, Created On, and Appointment Date. If there is no appointment date I want it to tell me how many days the cell has been blank since the date the delivery has been created. I am using a calendar table in Power Bi. Below is a sample of how I want it to work.
Sample

Need to calculate the number of days the cell is blank base on the delivery created date

New contributor

Greg Madden is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

LEAVE A COMMENT