New user

[krisso]

Im really new to Power BI and struggling on a couple of things and wondered if I could get some guidence.

I used to do all the following calculations via pivot tables in excel using a sharepoint version, but our IT people have said that this is causing the spreadsheet to crash and advised I use Power BI for this.

I have had no problems in creating the tables from the data in the excel sheet and linking them together but I am having problems from here.

On my pivots sheet I used to have 3 pivot tables that would look at data from 3 worksheets. This would be for a cashflow purpose so that I could see what was happening in the next 14 days. From this I would use a vlookup to pull out data from the pivot tables based on todays date and then enter a starting bank balance and the days cheques that had cashed through so I could forecast an end of day figure. Is there anyway I can do this in Powe BI?

Thanks

Chris

[Greg_Deckler]

There answer is probably "yes" but would have to see some sample data and some images or something of your expected results.

[krisso]

Thanks for your reply. My excel data looks like this

Date
16-Feb-17
Barclays Starting Balance	£2,647,717.02	Manually Entered
Todays Payments	653,428.61	Calc from look up from todays date
Todays Reciepts	960,850.00	Calc from look up from todays date
Cheques Cashed	6,321.15	Manually Entered
Predicted Barclays Balance	£2,948,817.26
All But ADF				ADF				Unallocated Funds
	Values				Values			Row Labels	Sum of Amount
Row Labels	Sum of To Send Out £	Sum of Expected In £		Row Labels	Sum of To Send Out £	Sum of Expected In £		13/02/2017	1,510.00
15/02/2017	620,807.61			17/02/2007	240,716.92			14/02/2017	1,535.00
16/02/2017	249,995.40	344,468.13		16/02/2017	403,433.21	615,871.87		15/02/2017	107,471.00
17/02/2017	557,695.62	802,894.92		17/02/2017	191,720.95	110,000.00		16/02/2017	510
22/02/2017		8,001.89		23/02/2017		73,415.00		Grand Total	111,026.00
23/02/2017		1,264,610.00		24/02/2017	91,500.00
24/02/2017	1,177,650.00	275		Grand Total	927,371.08	799,286.87
27/02/2017		205,767.40
28/02/2017	1,847,925.00	1,700,779.00
03/03/2017		37,703.62
(blank)		30,557.06
Grand Total	4,454,073.63	4,395,057.02

The 3 tables below feed into the top table as shown in the calculated fields from a vlookup. We manually enter the days starting balance and the cheques that have cleared through the bank. I just couldnt see how to replicate the top section in this excel spreadsheet on BI. I have imported the data but that is as far as I got. I couldn't see how to pull data based on todays date into another table and manually enter the figures I needed for the daily forecast

Thanks