topic Re: Saving timestamp daily in Report Server

Saving timestamp daily

htalat6 — Wed, 11 Jan 2023 17:25:59 GMT

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

Re: Saving timestamp daily

lbendlin — Sat, 14 Jan 2023 00:28:53 GMT

Power BI has no memory, and no concept of global variables. You need to do that in the upstream system.

Re: Saving timestamp daily

htalat6 — Sat, 14 Jan 2023 03:10:28 GMT

Hey thanks for the reply . It would be great if you share an article , i am new to Power BI and trying to solve this as soon as possible.

Re: Saving timestamp daily

lbendlin — Sat, 14 Jan 2023 11:15:27 GMT

Load your web data into a database and add the timestamp automatically during load ( using a default value of getdate() for example). Then access that database table from Power BI.