Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, I am checking to see if the status is greater than 15, then it should be "Yes"; otherwise, it should be "No". The syntax from example #1 is working. However, I noticed that many records were blank and should fall under "No", but they didn't. So I modified the syntax as shown in example #2, but I keep getting an error. I am new to DAX, so please assist me with this.
#1
if(Number.FromText([#"Warehousing Orders[LineStatus]"]))>15 then "Yes" else "No"
#2
Solved! Go to Solution.
Hi @hongho2
If you want to create the column in power query, you can add a custom column and refer to the following code
if Number.FromText([LineStatus])>15 and [LineStatus]<>null then "Yes" else "No"
If you want to create the column as a calculated column, you can refer to the following code
Column =
IF (
NOT ( ISBLANK ( 'Warehousing Orders'[LineStatus] ) )
&& VALUE ( 'Warehousing Orders'[LineStatus] ) > 15,
"Yes",
"No"
)
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @hongho2
If you want to create the column in power query, you can add a custom column and refer to the following code
if Number.FromText([LineStatus])>15 and [LineStatus]<>null then "Yes" else "No"
If you want to create the column as a calculated column, you can refer to the following code
Column =
IF (
NOT ( ISBLANK ( 'Warehousing Orders'[LineStatus] ) )
&& VALUE ( 'Warehousing Orders'[LineStatus] ) > 15,
"Yes",
"No"
)
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @hongho2
You're mixing DAX with M.
I assume you want to use M. Then, you only need to modify syntax in #1 to be like:
if(Number.FromText([#"Warehousing Orders[LineStatus]"]))<>null and (Number.FromText([#"Warehousing Orders[LineStatus]"]))>15 then "Yes" else "No"