Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

Calculation of rows with blank

Hello all,


I want to calculate a measure which have requirement like : 
Part received in current month but "Date Inspection Finished" is blank.
received date and inspection date is in date format.
I have to display this counting in the form of months.

Current month means that perticular month,please help me out to solve this
POWER BI @ blank

Community Support
Community Support

Hi @Yashodhan ,


Maybe you can try some code like this:


countrows( filter('table',  isblank([inspection date]) )


If you need more help, please share some example data and expect result even if hand drawn.


Best Regards

Community Support Team _ chenwu zhu


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User
Super User


Can you share some sample data with the desired output to have a clear understanding of your question?
Mention whether you want a calculated column or measure.
You can either paste your data in the reply box or save it in OneDrive, Google Drive, or any other cloud-sharing platform and share the link here.

Did I answer your question? Mark my post as a solution! and hit thumbs up

Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources


Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.