Forum Discussion
Incoming Username (embedded Dashboards)
Thnx for your reply.
Ths issue we have is that we need to calculate with time. 1 dashboard can have multiple users in different timezones. They need to see the data in their own timezone. For that reason, we need to recalculate time.
Community Supporthi, Anonymous
These function could not be used in calculated column, and I think you could use them to create a measure.
Please share some simple sample data and your expected output, we could have a test on it.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Best Regards,
Lin
Thnx all for your replies so far. I've added a small test dashboard to clarify my issue.
Steps: login as user test|4
pathitem returns 4 in measure 'item'.
The datetime field needs 4 extra hours provided by the pathitem measure. In this test I expect the current datetime + 4 hours
(field calculated time)
Again: a measure to solve this issue is not an option. I have to do a recalculation for each datetimefield in my data set so i need to add an new calculated column.
Anyone?