Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

True / False seen as Text Column - DAX Help!!!!

In my dataset, I have added an additional column that ouputs True, False or (blank).  Upon import, PBI sees it as text and I can't convert it to True/False in either Query Editor or in Data (left-rai...
Need Help
Show and Tell
Tips and Tricks
tjd's avatar
tjd
Impactful Individual
8 years ago

I'd try converting them on input to 0/1 and null and then see if they will convert to logical after inputting.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

tjd

 

Not sure that is an ideal solution.

 

Here's a little more context.

 

This column is newly added.  Like columns, from an earlier verision of the dataset, import as True/False - this one doesn't.  When I re-import in a NEW .pbix file, it imports with the correct format.

 

Not sure why I can't convert this one, or why a fresh "Get Data" works properly.  Would prefer not to rebuild the dashboards if possible.

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous,

    This might be fixed if you go into the query editor and see what automatic transformations Power BI makes when you import them,  please eliminate the step and and check if it works fine.

    If your data type can't be converted to True/False type, you can change your DAX as follows, it might work correctly.

    Column 2 = IF('KPI Dashboard AD'[(Campaign) Creative Concierge]="True","Complete","False"
)


    Best Regards,
    Angelia

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous,

    Have you resolved your issue? If you have, welcome to share your solution or mark the right reply as answer. More people will benefit from here.

    Best Regards,
    Angelia