Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to calculate difference between two columns and applying a filter

Hi all, I have 3 columns i.e   1st column "Dates" that consists of dates from 1st April 2022 till 23rd March 2023.   2nd column that has only one date that keeps updating for now it is 18th May ...
Need Help
v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, Anonymous 

If your report contains other slicers to filter the data, try measure formula like:

Completed Working Days = 
CALCULATE (
    COUNT ( 'Table'[1st column] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        'Table'[1st column] <= MAX ( 'Table'[2nd column] )
            && 'Table'[3rd column] = "Yes"
    )
)

Best Regards,
Community Support Team _ Eason