Forum Discussion
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/active systems in a certain period.
For example on 01-01-2023 there is an installed based of 1000, on 01-07-2023 there are 300 systems that we make inactive.
By check the installed based on 01-01-2023 showed the installed based of 700. What can I do to solved this ?
I have 2 tables:
- Hist_frontend
- Startdate
- Enddata
- Installation_frontend
- vc_frontendid (connetion to table VC_frontend)
- VC_frontend
- frontend
- ID (connection to table hist_frontend)
Like below:
Anyone have the solution?
Greets,
Jeffrey
6 Replies
Hi Jeffrey_VC,
I'd like to suggest you take a look at the following link about use EXCEPT function to compare current and previous record list to get specific status of records:
Solved: Check if record exists in previous month - Microsoft Fabric Community
Regards,
Xiaoxin Sheng
AnonymousI take a look of the link. But I think it is not the solution that I'm looking for.
Hi Jeffrey_VC,
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Hi Anonymous , How can I share/upload a PBIX?
