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:

 

 

also:

 

 

and:

 

 

Columns were returning good values till a few days ago when I had to do some tweakings around and somehow messed them up.

Any help is much appreciated.

 

cheers

  • 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

6 Replies

  • az38's avatar
    az38
    Community Champion

    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

      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

        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