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

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
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
171
Matt Allington
M
K
  • Question
Calculated fields with dynamic field names
Replies
0
Views
225
KarenXL
K
J
  • Solved
Issue with Power Pivot measures & slicers
Replies
4
Views
60
Jaunkalns
J
T
  • Question
Aggregation tables do not include real-time data
Replies
0
Views
110
TamirBasin
T
R
  • Question
Parameter to pass folder (static) and file name (dynamic) to a query as a source file
Replies
2
Views
616
rgs694
R

Forum statistics

Threads
1,215,039
Messages
6,122,802
Members
449,095
Latest member
m_smith_solihull

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