Forum Discussion
Calculate Token usage since time reference
I would like to track software license usage. At contract signature, we are given a specific number of tokens to rent software at our convenience. I currently have all the tokens amount we have ordered, with dates, in my datasource. Sometime we rent multiple products in the same day. How can I achieve a panel that would show the remaining number of tokens in our contract?
Here an example:
| Date | Token used | Remaining tokens |
| January 1, 2021 | 100 | 400 |
| January 10, 2021 | 50 | 350 |
| January 10, 2021 | 25 | 325 |
| January 20, 2021 | 200 | 125 |
| Token on contract | 500 | |
| Blue | in MySQL | |
| Red | Needs to be in PowerBI |
jfn -
You can do as:
7 Replies
jfn -
You can do as:Thanks ChrisMendoza , I think this is working... But my line chart show the slope the wrong way...? I should start with the full amount and then start going down... Any idea?
Actually, the RemainingTokens column reverts to the full amount when there's no credit being used... I need to find a way to use the remaining tokens from previous row...
