Store each latest date (refresh history) to a table OR other hack in power bi desktop

[MianAhsan]

Hi all,

I am about to lose my head to solve the following issue. It would be easy for members who usually use Power Query, but not for me, as i have done a little work with it (I have always used DAX).

I'm facing an issue related to data where i only have the first two columns ["Requirements", "Values"] of the following dataset as an example, and my target is to add a refresh date or some other hack that whenever my data got a refresh date is added here which could connect to Calendar table. Later, i will create a line chart that shows the percentage of "Requirements" linked to the "Values". Each time the report gets updated, the line chart shows a percentage trend.

Requirements	Values	Date Refresh
SysReq	48	3/1/2024
Not SysReq	8	3/1/2024
SysReq	48	3/2/2024
Not SysReq	8	3/2/2024
SysReq	50	3/3/2024
Not SysReq	6	3/3/2024
SysReq	51	3/4/2024
Not SysReq	5	3/4/2024
SysReq	51	3/4/2024
Not SysReq	5	3/4/2024
SysReq	51	3/5/2024
Not SysReq	5	3/5/2024
SysReq	51	3/6/2024
Not SysReq	5	3/6/2024
SysReq	50	3/7/2024
Not SysReq	6	3/7/2024
SysReq	51	3/8/2024
Not SysReq	5	3/8/2024
SysReq	51	3/9/2024
Not SysReq	5	3/9/2024
SysReq	52	3/10/2024
Not SysReq	4	3/10/2024
SysReq	54	New refresh date
Not SysReq	2	New refresh date

This is the end goal i want to achieve.

Can you please guide me if there is any hack/way around to achieve this goal?

@amitchandak , @Daniel29195 , @Idrissshatila , @Ritaf1983 , @Anonymous 

Regards,

Mian 

[MianAhsan]

@Daniel29195 ,

you are partially correct, i want to fetch date as a separate column on the basis of each refresh which is not defined/available in my dataset. So, each time data got refresh, date will add to my dataset such as indexing and later i will use these dates to create line chart trends.

Maybe any other hack/solution with power query OR how to accomplish with the backend? 
Thanks.

[Daniel29195]

@MianAhsan 

correct me if my understanding is wrong .

you want to create a data history base on the refresh date . 

if that is so,

the power query is an etl tool .this can't be done in power query , neither in dax ( as far as i know ) . 

this should be done  in the backend. 

hope this makes sense 

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠