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
    Icon for Community Champion rankCommunity 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
        Icon for Community Champion rankCommunity 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