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

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

  • jfn's avatar
    jfn
    Frequent Visitor
    3 years ago

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