Forum Discussion
Fetch value from column by category
Fixed it!
The problem was that the relationship between timesheetentry and employees in my original table was set to "double" while it's supposed to be "single". This was all.
v-piga-msft big thanks for your help and effort!
Hi wverheijen,
If it is convenient, could you share a dummy pbix file which can reproduce your scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)
Best Regards,
Cherry
Hi cherry,
I was working on duplicating a dummy report for you in the same structure as my original table. When replicating my table, i suddenly got the result I'm looking for.
So if I recreate my table to a dummy, it works nicely, but my original report in thes same structure doesn't. I've tracked a single user ID and it should appear exactly the same.
Any thoughts?
You can look into the report here: https://1drv.ms/u/s!Aq8v0AAEkXxvgapoGfLv0j6q61FncA
Fixed it!
The problem was that the relationship between timesheetentry and employees in my original table was set to "double" while it's supposed to be "single". This was all.
v-piga-msft big thanks for your help and effort!
Hi wverheijen,
You're welcome! It's glad that you have solved your problem.:smileyvery-happy:
Best Regards,
Cherry