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

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? 

  • az38's avatar
    az38
    Community Champion
    6 years ago

    well, LittlePero 

    if you could delete sensitive data from your report and share pbix-file it would be helpful for further troubleshooting

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

    • LittlePero's avatar
      LittlePero
      New Member
      6 years ago

      Fun stuff, I changed Data Format to General, again (tried this before) and Data Type to Whole Number (also tried this before), refreshed data from DB and it worked:

       

       

      Thx for help az38 !

       

      cheers