Forum Discussion

hongho2's avatar
hongho2
Frequent Visitor
2 years ago
Solved

checking for multiple fields

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 blan...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.