Forum Discussion

austena229022's avatar
austena229022
Frequent Visitor
1 year ago
Solved

IF cells contains data Power Query

I am looking at doing a simple formula so that if a cell contains data = True in Power Query

 

Something like a IF(ISNOTBLANK(Column)), "Yes", "No")

Need Help
Tips and Tricks
  • ryan_mayu's avatar
    ryan_mayu
    1 year ago

    austena229022 

     

    you can try this

     

    if [Column1] ="" then "no" else "yes"

     

    OR

     

    if [Column1] is null then "no" else "yes"

     

  • Ritaf1983's avatar
    Ritaf1983
    1 year ago

    Hi austena229022 
    If the column is text data type and we are talking about empty cells the the formula will be :
    if [test] <> "" then "Yes" else "No"

    If the formula is for numeric data types with "null" it will be :
    if [test 2] <> null then "Yes" else "No")

    The pbix is attached

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

2 Replies

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    1 year ago

    austena229022 

     

    you can try this

     

    if [Column1] ="" then "no" else "yes"

     

    OR

     

    if [Column1] is null then "no" else "yes"

     

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    1 year ago

    Hi austena229022 
    If the column is text data type and we are talking about empty cells the the formula will be :
    if [test] <> "" then "Yes" else "No"

    If the formula is for numeric data types with "null" it will be :
    if [test 2] <> null then "Yes" else "No")

    The pbix is attached

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.