Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

exclude certain text from a calculated column

Hi, I'm using the below dax to exclude the rows that contain certain text so that i could get the required value. Here's the dax: Column = IF( Sheet1[OD group] = "0-30", IF( Sheet1[Outcome] = "", IF...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anand24 Anonymous ,

     

    Thank you for your help with my query.

     

    I've made minor changes to the DAX formula and now I can see the expected outcome. Here's what I used:

     

    Column = IF(
    AND(Sheet1[Days to Decision] = "0-30", NOT(CONTAINSSTRING(Sheet1[UltimateParentDUNSNumber],"NSA"))),
    IF(Sheet1[Outcome] = "",
    Sheet1[Total Value]))

     

    Thanks again for your efforts!!!

     

    Regards,

    Mahesh

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anand24 I've tried both the formulas provided and I'm seeing only one output with both the formulas. below is the screenshot of the output

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anand24 Anonymous ,

 

Thank you for your help with my query.

 

I've made minor changes to the DAX formula and now I can see the expected outcome. Here's what I used:

 

Column = IF(
AND(Sheet1[Days to Decision] = "0-30", NOT(CONTAINSSTRING(Sheet1[UltimateParentDUNSNumber],"NSA"))),
IF(Sheet1[Outcome] = "",
Sheet1[Total Value]))

 

Thanks again for your efforts!!!

 

Regards,

Mahesh