Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
In Power Query, my table has a column "Data" with tables.
A lot of these tables are empty, so I'm looking for a way to check which are empty and create an additional column "NotEmpty" I can use as a filter.
I'm trying to add this step with function Table.IsEmpty but it's not working.
Solved! Go to Solution.
Hi, there's a similar query here: https://community.powerbi.com/t5/Desktop/Check-for-empty-table-before-expandRecordColumn/td-p/227793
hope this helps
dan
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |