Forum Discussion

Cepheus's avatar
Cepheus
Frequent Visitor
2 years ago

Windows Server Patch Report

Hello Everyone, I have an Excel file with things like comptuer name,  patch id, deployment date, installed status, deployment date etc. I am new to  PowerBI and started using it about a year ago but ...
General Comment
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Cepheus 

 

I ran the following test:

 

My sample:

 

1. Create a calculated table as follows

 

Date = VALUES('Table'[deployment date])

 

 

2. Create several measures as follow

 

Sum = 
CALCULATE (
    COUNT ( 'Table'[installed status] ),
    FILTER (
        'Table',
        'Table'[installed status] <> "failed"
            && 'Table'[deployment date] >= MIN ( 'Date'[deployment date] )
            && 'Table'[deployment date] <= MAX ( 'Date'[deployment date] )
    )
)

 

 

 

missingPatch = 
CALCULATE (
    SUM ( 'Table'[patch id] ),
    FILTER (
        'Table',
        'Table'[installed status] = "failed"
            && 'Table'[deployment date] >= MIN ( 'Date'[deployment date] )
            && 'Table'[deployment date] <= MAX ( 'Date'[deployment date] )
    )
)

 

 

Is this the result you expect?

 

If I've misunderstood you, please provide detailed sample data and the results you are hoping for: How to provide sample data in the Power BI Forum - Microsoft Fabric Community . Please remove any sensitive data in advance.

 

Best Regards,
Community Support Team _Yuliax

 

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