Nested IF help please

[Pricey79]

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

[raimon]

Try this - 

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

[pratyashasamal · Accepted solution]

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]

@pratyashasamal   Wonderful, thnak you very much 

[Idrissshatila]

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