Forum Discussion
Need help with returning values
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
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
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
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?
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
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