Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
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 |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |