Forum Discussion

tdailey77's avatar
tdailey77
Frequent Visitor
6 years ago
Solved

DAX comparison - VALUE OR FORMAT

Hello, I have my data source connected to Microsoft D365 Online, I used to use On-Prem that was connected to a SQL server. I am finding this change to be a huge pain in the %$@!   In my old report...
Data Protection
  • amitchandak's avatar
    amitchandak
    6 years ago

    tdailey77 , is po_opportunitydisposition is text column or whole number. Seem like the whole number. If so remove double quotes

     

    example

    Opportunities[po_opportunitydisposition]=936710003

amitchandak's avatar
amitchandak
Super User
6 years ago

tdailey77 , is po_opportunitydisposition is text column or whole number. Seem like the whole number. If so remove double quotes

 

example

Opportunities[po_opportunitydisposition]=936710003

tdailey77's avatar
tdailey77
Frequent Visitor
6 years ago

Thank you, this solved it!! Very much appreciate the quick response too! I've been stuck on this for weeks, I guess I know where to go for help now. 🙂

 

Tim