Need help with returning values

[LittlePero]

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

[az38 · Accepted solution]

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]

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]

@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]

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]

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]

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