Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
MianAhsan
Frequent Visitor

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

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.

RequirementsValuesDate Refresh
 SysReq483/1/2024
Not SysReq83/1/2024
 SysReq483/2/2024
Not SysReq83/2/2024
 SysReq503/3/2024
Not SysReq63/3/2024
 SysReq513/4/2024
Not SysReq53/4/2024
 SysReq513/4/2024
Not SysReq53/4/2024
 SysReq513/5/2024
Not SysReq53/5/2024
 SysReq513/6/2024
Not SysReq53/6/2024
 SysReq503/7/2024
Not SysReq63/7/2024
 SysReq513/8/2024
Not SysReq53/8/2024
 SysReq513/9/2024
Not SysReq53/9/2024
 SysReq523/10/2024
Not SysReq43/10/2024
 SysReq54New refresh date
Not SysReq2New refresh date

 

This is the end goal i want to achieve.

MianAhsan_0-1709305166563.png

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

@amitchandak , @Daniel29195 , @Idrissshatila , @Ritaf1983 , @community 

Regards,

Mian 

2 REPLIES 2
MianAhsan
Frequent Visitor

@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
Super User
Super User

@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! 🤠

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.