Forum Discussion
mgaut341
Helper II
Helper IICounting blank fields based on another column
I am trying to count how many blank cells I have in my 'status' column when my 'appt date/time' field has a value in the cell. I have tried the following formula CALCULATE(COUNT('CCHHS Imaging & Pr...
I was not able to get it to work, so I used a subtraction formula from the other result status' to get my correct answer.
v-saisrao-msft
Community Support
Community SupportHi mgaut341,
checking in to see if your issue has been resolved. And share the sample data or Pbix file.
Please let us know if you still need assistance.
Thank you.
mgaut341I was not able to get it to work, so I used a subtraction formula from the other result status' to get my correct answer.
- v-saisrao-msft
Hi mgaut341,
Glad your issue has been resolved. Please mark your reply as the solution, as it will help other community members.
Thank you.