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