Forum Discussion
New user
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 ...
There answer is probably "yes" but would have to see some sample data and some images or something of your expected results.
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
