Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Getting maximum concurrent license usage only

Dear Team,   I have to find out the maximum concurrent license usage in a day. So, if user is selecting a date say 6th Jan 2022, it should show maximum concurrent licenses used that day.  I am abl...
Need Help
v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

Hi Anonymous ,

 

That means create a new table in power bi data. In power bi, you can use DAX to create columns or measures.

Columns

Power BI calculates and saves the results when the user has finished writing the dax immediately.

Measures

Power BI calculates result depend on the current content when the user uses this measure.

 

As you said, "it will do calculation for 30 days*86400=2592000 rows which is not a feasible option.", so, creating a new table or column in advance, rather than adding this table as a procedure table in the measure, will improve performance. 

 

Then create a measure i have posted for filter pane.

 

You can share your pbix file without sensitive data if you need more help.

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi v-chenwuz-msft ,

 

Is it possible to calculate maximum licenses used only for the dates selected in new table. For eg:

If user selects 14th Jan 2022, then all the time periods of that date should have maximum license value in new table

Is this possible? If yes, how?

Also, I am modifying my pbix file to keep only required data and will attach it shortly