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.
