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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
naveen73
Helper III
Helper III

Extrapolation using data from MS Access table

Hi all,

 

I have the following data from an MS Access table is as below:

 

naveen73_0-1708382699865.png

 

I want to extrapolate in Power Query.

  • Every month I have end-of-day values
  • I want to pass the date values from my Excel cells: H1-J1
  • The extrapolation is simple: take the difference between two end of month values and divides this by the number of days between the end of month dates. Then multiple this by the difference between the last end of month and the date of which the extrapolation needs to be performed.
  • When the date in H1-J1 is after the date in column C the value should be zero.
  • The data will be updated every month as it adds new data to the table for each new month.

 

Please see links to MS Access and MS Excel files.

 

https://docs.google.com/spreadsheets/d/1HpTgrvfwqjncsuCN9UbojMsRS5tWw0Hl/edit?usp=sharing&ouid=11029...

 

https://drive.google.com/file/d/1-IHPBZpk_lauermdYjSXUlUsyU5m-mF4/view?usp=sharing


thanks,

 

Naveen

2 REPLIES 2
lbendlin
Super User
Super User

I said it before and I'll say it again - Feb 28 is not EOM ! Please correct your sample data.

Hi,

 

Thanks for this.  I updated the data in the file. Click on the link to download.

 

Thanks,

Naveen

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors
Top Kudoed Authors