Saving timestamp daily
Scenerio I am connecting PBI report servver with Jira and getting the data from web My data does not have a specific time stamp which keeps the track of date when the status of issue changes. Now, i am thinking to create a column in my data that record the date and state of the other columns new data will add as an row forexample 1/10/23 x y date 1 2 1/10/23 on 1/11/23 x y date 1 2 1/10/23 4 8 1/11/23 I am using Today function as a new measure but it is only showing me today's data
Different time in online report vs. desktop / last refresh time and created time
Hey there I think I watched almost every tutorial video to this topic but I'm obviously missing something. I have problem with the local time showing correctly in the online reports. In the desktop report every thing is fine and correct according to my data source sharepoint - but online all the times are 2 hours behind, despite to formatting them to local zone times. As for the formating of the columns e.g. the last data refreshing time in my desktop report: - new Query with custom column - used formula: DateTimeZone.LocalNow() - data type: Date/Time/Timezone I'd be verry thankful if anyone could tell me what I am doing wrong.
WTD, MTD, YTD working hours of each employee with different timestamps for each day using DAX
This is a sample data. I need to calculate working hours in DAX. Working hours for one day = Last Timestamp of the day - First Timestamp of the day It is easy to calculate for one day but I can't seem to figure out how to calculate total working hours WTD, MTD, YTD. Every day timestamps are different and we want working hours for each Worker(Name) separately. Please guide. I can share the actual data as well if anybody requires. amitchandak Anonymous Jihwan_Kim daxer-almighty PaulOlding Fowmy
