Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi ,
How to get the count of blank and non -blank for all columns in the data by grouping report date
Need to structure the table into following format :
@amitchandak It's not working like i need to first get the column names of all columns in foirst column.
You can use countblank(Table[COlumn])
count(Table[Column])
or
countx(filter(Table, not(Isblank(Table[Column])) , Table[Column])
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.