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 issues" &&
'file'[No Filing Requirement] = "No",
"1",
"0")
 
However, while filtering new column_3 & see that there's one row in [office] column that contains data, while it should be blank. What am I doing wrong? 
 
Thank you for your support.
Kasia
Need Help

3 Replies

  • 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!