Forum Discussion

LittlePero's avatar
LittlePero
New Member
6 years ago
Solved

Need help with returning values

Hi guys,   this could be rather simple, but for the love of God I can't figure it out. My view is returning through CASE 0 or 1 values and in the BI desktop I'm getting -1 values in my 3 columns: ...
Need Help
  • az38's avatar
    az38
    6 years ago

    hi LittlePero 

    what values do you see in Power Query Editor mode and in Data window in report mode?

    do not hesitate to give a kudo to useful posts and mark solutions as solution

az38's avatar
az38
Community Champion
6 years ago

hi LittlePero 

what values do you see in Power Query Editor mode and in Data window in report mode?

do not hesitate to give a kudo to useful posts and mark solutions as solution

  • LittlePero's avatar
    LittlePero
    New Member
    6 years ago

    Thx for the fast reply, I can't see it trough BI:

     

    but can trough VS or Tabular Editor:

     

     

    Values are 0 or -1 instead of 1.

     

    cheers

     

     

    • az38's avatar
      az38
      Community Champion
      6 years ago

      LittlePero 

      please, share your statement with CASE that defines the value. without it, it's almost impossible to help 

       

      do not hesitate to give a kudo to useful posts and mark solutions as solution

       

      • LittlePero's avatar
        LittlePero
        New Member
        6 years ago

        Sure, here it is:

         

        As said before, the function worked good, it was returning values as it should, I don't think it's the cause of the problem. Could it be some miss-match of the date formats fields in "Date" view I was changing few days before?