Forum Discussion

Pricey79's avatar
Pricey79
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 (doesn...
Need Help
  • pratyashasamal's avatar
    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

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Try this - 

 

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