Forum Discussion

kasiak's avatar
kasiak
Frequent Visitor
4 years ago
Solved

SWITCH help with blank()

Hi, I wanted to create new column with formula below:   column_3 = SWITCH( TRUE (), 'file'[office] = BLANK() && 'file'[Current Task] = "Record Completed" && 'file'[Service Status] = "No iss...
Need Help
  • kasiak's avatar
    kasiak
    4 years ago

    Thank you Greg_Deckler I think I solved it 🙂

    Thanks!

    BR,

    Kasia

kasiak's avatar
kasiak
Frequent Visitor
4 years ago

Thank you Greg Greg_Deckler for your reply. I'm not sure if I understand correct 🙂

So, is the first condition wrong? My aim is to show only blank rows within office column, but only if other conditions are met too:

'file'[Current Task] = "Record Completed" &&
'file'[Service Status] = "No issues" &&
'file'[No Filing Requirement] = "No"
 
Could you please clarify? I'm a beginner in dax:) thank you!