Forum Discussion

Jeffrey_VC's avatar
Jeffrey_VC
Helper III
2 years ago

Measure couting install based

Hi everyone,   I try to make a measure that counts the installed based of our active systems. With the fuction count it is possible to count the installed based, but my challange is the inactive/a...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

HI Jeffrey_VC,

You can upload to network drive and create a share link here or directly paste the data here as table format.

Notice: please not attach sensitive data in your files or sample data.

Regards,

Xiaoxin Sheng

Jeffrey_VC's avatar
Jeffrey_VC
Helper III
2 years ago

Hi Anonymous,

 

I have place the pbix on:

https://drive.google.com/file/d/1_q3_Qz0S5BS2HanAEhQCugT9bpTIuv5E/view?usp=drive_link

 

 

The table "vc_frontend" are all the systems.
The table "Hist_frontend" showed the history of the installation(s).
When the installation is stuck of replaced, the table "hist_frontend wil be filled with start or enddate. (or both).

 

I need the install based by month of the installations with no enddate from the table hist_frontend. If a installation have a enddate I need to count them till the endate.


Hopefully this is clear for you.

Greats, Jeffrey