Forum Discussion

t-irp's avatar
t-irp
New Member
3 years ago
Solved

Another DAXComparison Operations Do Not Support Comparing Values Of Type Integer With Type Text

Hello, I did a search and found a similar post but despite my efforts to solve my own issue, I am blocked and could use some guidance. I did follow the steps in that other post, which were quite c...
DAX
  • t-irp's avatar
    t-irp
    3 years ago

    I made a lot more progress. It seems that the value 1000 is a string, not a number.

    This

    ReportValue (DAX) = Switch(TRUE(), FORMAT(GL_BALANCE_MC[Cost_Center],"Standard") = FORMAT(1000,"Standard"), "Cash")

    gets me past the error. Hopefully it helps someone

  • t-irp's avatar
    t-irp
    3 years ago

    Sorry for the late reply, = the issue was that "1000" needed to be a string for whatever reason.

FreemanZ's avatar
FreemanZ
Super User
3 years ago

hi t-irp 

 

what kind of data do you have for column GL_BALANCE_MC[Cost_Center]?

t-irp's avatar
t-irp
New Member
3 years ago

That data coming from the vendor DB is "text". I have selected that column in Power BI and changed to "whole number" but that is not solving my issue, so I am doing something else wrong it seems.

  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago

    hi t-irp 

    regardless its data type, what kind of value do you have?