Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
How do I extract the plain text from columns in HTML and exclude null values? I have a column that has a mix of plain text, HTML, and null values.
I tried using "Html.Table([ColumnName] , {{"text",":root"}})" but when it hits a null value, it breaks everything.
' try Html.Table([Column] , {{"text",":root"}}) otherwise null '
Hello @walker21 ,
I don't know if you still need assistance but I have a workaround if you need.
Simply replace the null value with NA in the column and then create another column using this formula "Html.Table([ColumnName] , {{"text",":root"}})".
In this way you will not get the error message 😉
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
89 | |
84 | |
76 | |
64 |
User | Count |
---|---|
135 | |
112 | |
98 | |
98 | |
92 |