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.
Hello,
could anyone tell me what is wrong with the following statement:
Column = IF Query[CR] = NaN then 0 else Query1[CR]
Thank you,
Ekaterina
= NaN won't work either in Power Query.
Working example query:
let Source = Table.FromList({1,#nan,2}, Splitter.SplitByNothing(), {"CR"}, null, ExtraValues.Error), #"Added Custom" = Table.AddColumn(Source, "Custom", each if Number.IsNaN([CR]) then 0 else [CR]) in #"Added Custom"
@Anonymous well I select Query1[CR] as Power BI advices me in the bar so it knows from which query am I selecting CR. I have tried to replaced IF for if and tried both without Query1 and with it, but it returns me an error anyway. It says that ''the syntax for ´then´ is incorrect. (DAX(IF (Query1[CR] = NaN then 0 else Query1[CR]))).''
@MarcelBeug's reply should work for Power Query.
For DAX you can try
Column = IF(Query[CR]="NaN","0",Query[CR]) or Column 2 = IF(ISBLANK(Query[CR]),"0",Query[CR])
Your Query seems to be a DAX Query..
@MarcelBeugand I posted you Power Query solutions (I have to admit, that only @MarcelBeug solution works, as I've overlooked the NaN issue....)..
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 |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |