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.
inside the CALCULATE formula, I can use filters.
usually I filter blanks using:
data=BLANK()
But another developer here uses this:
LEN(data)=0
Both filters return the same final value, but which filter is the correct one?
in my example, I am filtering off blank dates from my dataset.
How can I test this and be 100% sure of the correct filter?
Is NULL and BLANK the exactly same thing for Power BI? All related material I find shows only blanks, never shows null values.
Solved! Go to Solution.
@Anonymous wrote:
thanks for your answer, but I asked DAX, and you showed M language inside Query Editor.
DAX is used only in the Report view for measures and calculates columns or tables. Inside Query Editor it is M language.
Anyway, if they both commands work the same way, when should I use one or another?
@Anonymous
I showed the null and empty("") difference in data model in M(Query Editor) and Data tab in report designer window, if you look into my snapshot carefully.
Though I think they're equal, I'd use BLANK() when I comparing/counting blank values and use LEN to compare text type(Returns the number of characters in a text string) to make my DAX more comprehensible.
@Anonymous wrote:
inside the CALCULATE formula, I can use filters.
usually I filter blanks using:
data=BLANK()
But another developer here uses this:
LEN(data)=0
Both filters return the same final value, but which filter is the correct one?
in my example, I am filtering off blank dates from my dataset.
How can I test this and be 100% sure of the correct filter?
Is NULL and BLANK the exactly same thing for Power BI? All related material I find shows only blanks, never shows null values.
@Anonymous
Power Query treats the empty("") and null as different, however, DAX seems to treat them as the same.
So the three in DAX shall work the same way.
Column = [a]=BLANK() Column = [a]="" //equal to LEN([a])=0 Column = LEN([a])=0
thanks for your answer, but I asked DAX, and you showed M language inside Query Editor.
DAX is used only in the Report view for measures and calculates columns or tables. Inside Query Editor it is M language.
Anyway, if they both commands work the same way, when should I use one or another?
@Anonymous wrote:
thanks for your answer, but I asked DAX, and you showed M language inside Query Editor.
DAX is used only in the Report view for measures and calculates columns or tables. Inside Query Editor it is M language.
Anyway, if they both commands work the same way, when should I use one or another?
@Anonymous
I showed the null and empty("") difference in data model in M(Query Editor) and Data tab in report designer window, if you look into my snapshot carefully.
Though I think they're equal, I'd use BLANK() when I comparing/counting blank values and use LEN to compare text type(Returns the number of characters in a text string) to make my DAX more comprehensible.
I had a problem, that if I used BLANK() statement with int column, it filtered BLANK() and 0s as well.
instead: table[column] = BLANK()
use: LEN(table[column]) <> 0
SOLVED my problem
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 |
---|---|
17 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
22 | |
2 | |
2 | |
2 | |
2 |