Display Active NAV licenses over time

[Rabacov]

Hello all,

I wonder if anyone could help with this. The IT team from the company I work for are currently looking into building a Power BI Dashboard and display the number of active Microsoft NAV active licenses at any given point in time. 

I managed to find a SQL table on NAV that has the following columns:

Server Instance ID	Session ID	Event Datetime	Logon	Client Type	Database Name
1227	52	28/10/2017 10:01	Logon	0	ActeonNAV
1227	52	28/10/2017 10:41	Logoff	0	ActeonNAV

For every Session ID, there is a Logon and Logoff time. I then created a new column with SQL called "duration" which is basically doing "logoff time - logon time". This would indicate how long that Session ID was active for. 

I wonder now how is the best way to go about creating this graph with Power BI? This should be a line chart that would show the number of active licenses over time. In other words I would be using a count of Session ID for anytime this comes active at any given point in time. 

Any ideas? 

Thanks in advance

Best

Eric

[v-chuncz-msft · Accepted solution]

@Rabacov,

Here is a similar case. You may have a look.

https://community.powerbi.com/t5/Desktop/Trend-from-History-Table/td-p/199565