Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi PBI-lovers
I’ve been struggling a couple of days with the calculation of walletbalances in Power BI.
We are working with customers who have a so called “Wallet”.
https://www.dropbox.com/s/2v5bqg5rd7h2l6i/190115%20Dummydata%20Balances%20Community.xlsx?dl=0
In the first worksheet you will find all the data:
Timeperiod = Year/Month
ClientId = ClientID
Balance_start_period = The startbalance of the wallet
Revenue - Purchases, normally “Balance Out” but it is possible to have a “Balance In” if the purchase has failed.
Payments = Payments (= Balance In)
Cashback = In certain circumstances a customer receives a cashback (=Balance In).
Balance_end_period = The endbalance of the wallet
Worksheet 2 t/m 6: calculations in Excel of the different customers.
Additional information for Cashback:
Revenue Cashback: if Revenue < 0 then Revenue else 0.
Endbalance Cashback: If (startbalance CB + Revenue Cashback + Cashback) < 0 then 0 else (Startbalance CB + Revenue Cashback + Cashback)
Extra:
It is possible to have a wallet < 0, those are Accounts Receivable Customers.
Can someone help me to do the Excel-calculations in Power BI?
Thanks in advance,
Greetings from Holland,
Cor
When you only have one wallet or app to keep track of your finances and various assets, it's convenient. When you have everything distributed across different applications, it can be easy to miss something. What makes solutions like web3 wallet nonbank truly innovative is the ability to combine all your wallets into one app. Тhere is no need to worry about safety. Thanks to KYC verification, you don’t have to worry about someone getting access to your data.
@Anonymous,
It seems that you may just add custom column in Query Editor.
See pbix-file: https://www.dropbox.com/s/favgmmgcd56ts6x/190116%20PBI%20Dummy%20data.pbix?dl=0
I have made a few columns in the Query Editor.
The problem is the calculation of the endbalance of the cashbacks, see picture.
https://www.dropbox.com/s/iowq3v1a1q2nmk2/Cashback.png?dl=0
For example ClientID 699, 2018 September gives 0,30, in October there are no transactions, so the endbalance needs still to be 0,30 and not 0,00. Can you help me with the formula for calculating the correct endbalance?
Is there no one who can help me?????
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |