Calculate from Sub-data set (by Modified file)

M

msarfaraz

New Member
Joined
Oct 18, 2012
Messages
46
565993
I have a scenario where daily report file copy in my folder by date and this file are connected to my Power BI report (Folder extract) . how I can calculate the difference data from two different files. Example if I want to calculate data from 1st November till 02 November what formula I should use.
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

iosiflupis
  • Question
Power BI .csv and/or .xls* files and Incremental Refresh
Replies
1
Views
165
Matt Allington
M
K
  • Question
Calculated fields with dynamic field names
Replies
0
Views
224
KarenXL
K
T
  • Question
Aggregation tables do not include real-time data
Replies
0
Views
106
TamirBasin
T
R
  • Question
Parameter to pass folder (static) and file name (dynamic) to a query as a source file
Replies
2
Views
604
rgs694
R
D
  • Question
Power Query refresh taking HOURS after adding custom column
Replies
3
Views
295
Matt Allington
M

Forum statistics

Threads
1,214,825
Messages
6,121,788
Members
449,049
Latest member
greyangel23

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top