Forum Discussion
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 ...
Hi, srana
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
v-easonf-msft
Community Support
Community SupportHi, srana
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