Hi all, using the tables Membership and Usage, how can I calculate scheme utilization rate for 2022?
Member ship has start and end dates
Usage has creation date, cost columns.
I guess count(cost) against/total active policies in that period gives utilization ratio.
Can anyone help me with DAX query for getting the result?
DATASET-XL.xlsx (535.5 KB)
Bumping this post for more visibility from our experts and users.
While waiting for other members to jump in, I suggest using the forum search to discover if your query has been asked before by another member. Thanks!
Hi @_,
Due to inactivity, we’d like to conclude that your inquiry was out of the experts and users’ bounds.
If you were sure you provided all pertinent context to your concerns and read how to use the forum more effectively and still find your question unanswered, your membership also comes with relevant resources that may help you with your Power BI education, so we advise that you check these resources as well.
While our users and experts do as much as reasonable to help you with your inquiries, not all concerns can be attended to especially if there are some learnings to be done. Thank you!