Forum Discussion

rachaelwalker's avatar
rachaelwalker
Icon for Resolver III rankResolver III
6 years ago
Solved

Aggregating Quick Measures

I created a quick measure to show the sum of business workdays between two dates. In another visual, I want to show the average of workdays per project manager, however; it does not give me an option...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi rachaelwalker ，

    Please try to update the existed calculated column "Warranty to Sent Invoice" as below to get the working days between two days:

     

    Warranty to Sent Invoice =
IF (
    ISBLANK ( 'Projects'[WarrantyStart] ) || ISBLANK ( 'Projects'[Invoice Sent] ),
    0,
    CALCULATE (
        COUNTROWS ( 'Query2' ),
        FILTER ( 'Query2', WEEKDAY ( 'Query2'[Date], 2 ) < 6 ),
        DATESBETWEEN (
            'Query2'[Date],
            'Projects'[WarrantyStart],
            Projects[Invoice Sent]
        )
    )
)

     

    Best Regards

    Rena

rachaelwalker's avatar
rachaelwalker
Icon for Resolver III rankResolver III
6 years ago

For security reasons, I will send it directly to you

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi rachaelwalker ，

Please try to update the existed calculated column "Warranty to Sent Invoice" as below to get the working days between two days:

 

Warranty to Sent Invoice =
IF (
    ISBLANK ( 'Projects'[WarrantyStart] ) || ISBLANK ( 'Projects'[Invoice Sent] ),
    0,
    CALCULATE (
        COUNTROWS ( 'Query2' ),
        FILTER ( 'Query2', WEEKDAY ( 'Query2'[Date], 2 ) < 6 ),
        DATESBETWEEN (
            'Query2'[Date],
            'Projects'[WarrantyStart],
            Projects[Invoice Sent]
        )
    )
)

 

Best Regards

Rena