Forum Discussion
active users over a period
Your yearly budget amount per app doesn't vibe with the data model, so the budget table will have to stay disconnected, and you will have to use LOOKUPVALUE for any annual measures.
"End goal is to find out cost per application per month per loginID"
Which visual are you planning to use fo that, and when does the budget come into play?
Your sample data is inconsistent, the budget mentions PowerBI (sic) and the usage mentions PowerApp (sic). I took the liberty to change both to Power BI.
Sorry for the confusion.I fixed that application name inconsistency.Here is where i am currently in the model with just headcount calculated but i dont know how to calculate the costs per application.I have referred to plenty of resources earlier for a month but no luck in designing this with the budget fact as the granularity is different.I have been unsuccessful in building correct relationships betwen tables to get this working.
To answer your Q:
Which visual are you planning to use fo that, and when does the budget come into play?
There is an amount budgeted for each application forecast upto 2023.Requirement is to find how much is per user cost per application on a given month at lowest level,then roll up to qtr,year.The per user cost is budget amount /headcount
I also felt since there are 2 facts- usage and budget,i am not sure how to get the costs.I couldnt do facts consolidation as well.
I will be really grateful to you and happy if you can help me with the cost measure.
Attaching the model with the fixes.I just created a calculated table Budget_F with monthly granularity to try something,so pls ignore if it is not required.
https://drive.google.com/file/d/16rCk0jSJwZ25fDCZbsVzp0yYxk0kU4LZ/view?usp=sharing