Forum Discussion

Helper V

3 years ago

Solved

Nested IF help please

Hello everyone, I was hoping someone could help me please. I'm really struggoing with this for some reason

I have two columns, and I would like to create a new column that says True or Yes (doesnt matter really) if both columns have an entry in them.

How would I do this please?

Thank you

pratyashasamal
3 years ago
Hi Pricey79 ,
Please try this ,
True/False = IF (
NOT(ISBLANK(Orders[Sales Total]))&& NOT(ISBLANK(Orders[SalesByCatergory])) , "Yes","No"
)

Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

4 Replies

Idrissshatila
Super User
3 years ago
Hello Pricey79 ,

Try this measure

Column = IF('Table'[Column1] <> BLANK() && 'Table'[Column2] <> BLANK(),"True","False")

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
pratyashasamal
Memorable Member
3 years ago
Hi Pricey79 ,
Please try this ,
True/False = IF (
NOT(ISBLANK(Orders[Sales Total]))&& NOT(ISBLANK(Orders[SalesByCatergory])) , "Yes","No"
)

Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
- Pricey79
  Helper V
  3 years ago
  pratyashasamal Wonderful, thnak you very much
Anonymous
Not applicable
3 years ago
Try this -

    IF (
        OR (
            ISBLANK ( 'Table'[Column1] ),
            ISBLANK ( 'Table'[Column2] )
        ),
        FALSE (),
        TRUE ()
    )