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.
I have Table with Class Code and Description. Class Code and Description reside in different tables.
The column Description fills in from Class Code. I was able to create Unknown for Blank for Class Code.
So I do create a Custom Column or Conditional Column to get Description to show Unknown instead of blank?
Solved! Go to Solution.
Hello @bdehning ,
You could in power query replace blanks with unknown using the replace values function,
check this link for instructions https://learn.microsoft.com/en-us/power-query/replace-values
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
Hello @bdehning ,
You could in power query replace blanks with unknown using the replace values function,
check this link for instructions https://learn.microsoft.com/en-us/power-query/replace-values
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
I am not sure who marked it solved. But not solved, as not as simple to just use replace values.
As explained, Class Code and Description are in two different tables and Description does not contain any null values.
Description is determined from Class Code value and I have to select last when Description is placed as a column. I was able to replace Null in Class Code with unknown.
When Class Code encounters a null value is correctly displays Unknown in the table, but Description leaves a blank and it has no way to assign a value for null or unknown as it does not contain either.
Since Description is a on table on Server, how could I add a Row to this table to insert a Row that has null value. That seems it may work, right?
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |