Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I'm trying to filter out what I think are blank values from a list. Unfortunately, they dont' show as Blank(), don't show as "null" and don't seem to be empty strings ("").
How do I determine the datatype of these values?
How would I eliminate them from the data using DAX?
Solved! Go to Solution.
how did you understand this is not the "" ?
try, like
Column =
SWITCH(TRUE(),
ISBLANK([ID]), "1",
[ID] = "", "2",
"Other")
also it will be a good idea to look at data source in Power Query. Does look the same?
Thought this has been solved, there is a way to find out in Power Query.
If you go to one of those mistery rows > right click > replace values, it will automatic identify its content and fill it into "Value To Find".
Hope this help.
Hi @ericOnline
it maybe a space or a few spaces in row, for example.
to debug create a calculated column
debug = LEN([ID])
the better way is to execute trim operation for this column in Power Query Editor mode
also try ISTEXT() or ISNUMBER() functions to understand data type
@az38 thanks for the idea. What do you make of these results?
- I filtered by Blank(?) value
- Created a new calculated column
Results:
how did you understand this is not the "" ?
try, like
Column =
SWITCH(TRUE(),
ISBLANK([ID]), "1",
[ID] = "", "2",
"Other")
also it will be a good idea to look at data source in Power Query. Does look the same?
User | Count |
---|---|
131 | |
71 | |
70 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
65 | |
62 | |
53 |