Forum Discussion

SevsBo's avatar
SevsBo
Responsive Resident
3 years ago
Solved

Conditional Column not returning expected results

I have a column with data where I need to filter out lines with specific phrases and have found that the Conditional Column is not returning the results I would expect.   The column it's drawing fr...
Need Help
  • DOLEARY85's avatar
    DOLEARY85
    3 years ago

    Hi,

     

    can you use power query and do this in a custom column prior to a calculated column?

     

    if so try: 

     

    if Text.Contains([Text Field],".Phrase.") then "X" else "Y"

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

DOLEARY85's avatar
DOLEARY85
Resident Rockstar
3 years ago

Additionally if you need to use DAX you could create a calculated column with the below:

 

Column = if(CONTAINSSTRING('Table Name'[Text Field],".Phrase."),"X","Y")
 
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍