Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
let ColumnNames = Table.ColumnNames(DatabaseRecords(num)), Tabled_Column_Data = ConvertToTable_SubTable(Table.Column(DatabaseRecords(num), ColumnNames{1})), objects = #table( {"Name", "Key", "Data", "ItemKind", "ItemName", "IsLeaf"},{ {ColumnNames{0}, ColumnNames{0}, ConvertToTable_SubTable(Table.Column(DatabaseRecords(num), ColumnNames{0})), "Table", "Table", true}, {ColumnNames{1}, ColumnNames{1}, ConvertToTable_SubTable(Table.Column(DatabaseRecords(num), ColumnNames{1})), "Table", "Table", true}, {ColumnNames{2}, ColumnNames{2}, ConvertToTable_SubTable(Table.Column(DatabaseRecords(num), ColumnNames{2})), "Table", "Table", true}, {ColumnNames{3}, ColumnNames{3}, ConvertToTable_SubTable(Table.Column(DatabaseRecords(num), ColumnNames{3})), "Table", "Table", true}, {ColumnNames{4}, ColumnNames{4}, ConvertToTable_SubTable(Table.Column(DatabaseRecords(num), ColumnNames{4})), "Table", "Table", true} }), NavTable = Table.ToNavigationTable(objects, {"Key"}, "Name", "Data", "ItemKind", "ItemName", "IsLeaf")
I am using this to create 5 items on a navigation table. I want a if statement for the last one aka 4th that checks t see if ColumnNames{4} is null, if it is then don't add it to the objects table. Is this possible?
I think you can try Table.RowCount function in your M query. If count not blank row equal to 0, then return null.
Here I find a offical blog about Handling Navigation, I hope it could help you solve your problem.
For reference: Handling Navigation
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
5 | |
4 | |
3 | |
2 | |
2 |
User | Count |
---|---|
8 | |
6 | |
4 | |
4 | |
4 |