hi Friends,
Requirement:
Create a query or Power BI report/dashboard that displays users, their Pro License operations usage in a 2 months time frame.
Example: Consider the below table data
Here user John had a Pro License but he performed view operation more times which can also be performed with a Premium License. For View operation, he doesn't need a Pro License. So, based on the operations field in the above table, we need to create a report which displays the % of Pro Usage by a user in a time period.
Can anyone please provide a query to achieve this?