Forum Discussion

jfn's avatar
jfn
Frequent Visitor
3 years ago
Solved

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 order...
Need Help
Tips and Tricks
ChrisMendoza's avatar
ChrisMendoza
Resident Rockstar
3 years ago

jfn -
You can do as:

  • jfn's avatar
    jfn
    Frequent Visitor
    3 years ago

    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's avatar
      jfn
      Frequent Visitor
      3 years ago

      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's avatar
        ChrisMendoza
        Resident Rockstar
        3 years ago

        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.