Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Referencing Cells in a Power Query If Statement

Hi, Is the formula below possible in Power Query? Its giving me an error because it can't reference the cell below labeled "AB2". I assume its because I can't have a dynamic formula where in the following row it reads AB3. Is this even possible in power query?

 

 

Need Help
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    Hi Anonymous 

    It is possible.
    Better you can try for conditional column inplace of custom column

    I am sharing one sample


    If solve your requirement, please mark as Solved

1 Reply

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    Hi Anonymous 

    It is possible.
    Better you can try for conditional column inplace of custom column

    I am sharing one sample


    If solve your requirement, please mark as Solved