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...
Jeffrey_VC's avatar
Jeffrey_VC
Helper III
2 years ago

Hi Anonymous , How can I share/upload a PBIX?

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