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

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