Calculate Token usage since time reference

[jfn]

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

[ChrisMendoza · Accepted solution]

@jfn -
You can do as:

[jfn]

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?

[jfn]

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... 

[ChrisMendoza]

@jfn - I feel like I don't have enough understanding of your data model to replicate your issue as my example outputs as I would expect. I recommended reviewing the pattern/technique described at Computing running totals in DAX - SQLBI which is what I've used in this solution with my sample data. If you would like assistance with your data/.pbix you'll need to include as such.

Find the attached .pbix file for your review.

[jfn]

@ChrisMendoza, I'm currently reviewing the link you sent as well as your PowerBI file. For reference, here's a link to my PowerBI file... https://ksheng-my.sharepoint.com/:u:/g/personal/jfn_ksh_ca/EdJSoV9sAJ1Ag6BD8J-9Nt4BQLCGQA36DyjU9NvEC... 

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[jfn]

ok, It seems to work now... I just needed to change the setting for the date; from Date Hierarchy to StartDate... Now I just need to find how to generate a date for each day (not skipping any date)...