Forum Discussion

tejapowerbi123's avatar
tejapowerbi123
Helper V
3 years ago

FIRSTNONBLANK with Filter Condition

Hello Community,

I am trying to get the Product Desc with the help of FIRSTNONBLANK,
How can I add condition if Product Desc=”not found” then select second record.

CALCULATED COLUMN=
FIRSTNONBLANK(SELECTCOLUMNS(RELATEDTABLE('Pri Book Entry'),"New Unit Price",'Pri Book Entry'[Product Desc]),TRUE())

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi tejapowerbi123 ,

     

    According to your statement, I think your statement is to create a Product Desc column whose data is not blank. I think you just need to add a filter like 'Pri Book Entry'[Product Desc] <> BLANK().

    If this reply still couldn't help you solve your issue, please share a sample file with me and show me the result you want.

     

    Best Regards,
    Rico Zhou

     

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