Forum Discussion
Different values in the same report for different users
The problem was solved,
It seems like using "datesinperiod" function made some problems when switching between versions (it didn't work as is should have been). I just found another way to calculate what I needed.
Hi,
This is what I see:
Meaning I can't click on it, it happens when I enter the report in my team's workspace, and also when I upload the report by myself to my workspace.
Hi Rons,thank you for your feedback.
Make sure your date column is date type or date/time type, not the text type.
Please try to clear the data cache in Power BI Desktop, go to File > Options and settings > Options > Data Load, then click Clear cache:Additionally, please specify the data source mode in your report (Import or DirectQuery).
If you are using DirectQuery, ensure that user permissions are correctly set based on the data source.
Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
It doesnt work and they are all date type.
I did find out my coworker is using a different PBI desktop version than mine, I use May 2024 and she uses July 2024.Hi Rons, thank you for your feedback.
We suggest you both get the latest version of Power BI Desktop from the Download Center to compare the result.
Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.