Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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 |
Solved! Go to Solution.
@jfn -
You can do as:
Proud to be a Super User!
@jfn -
You can do as:
Proud to be a Super User!
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...
@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.
Proud to be a Super User!
@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...
Hi,
You may download my PBI file from here.
Hope this helps.
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)...
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
81 | |
79 | |
58 | |
35 | |
34 |
User | Count |
---|---|
99 | |
59 | |
56 | |
46 | |
40 |