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

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