How to create COUNTIF MEASURE with conditions based on user inputs from date slicer?

[syazwan95]

Hello everyone, I'm trying to do a quite simple thing, but I cant seem to find a workaway around it.

I have the following data in a table:

and the following date slicer:

What I want to do is to have an "After Period" column where if the "AB Delv Da" is later than the end date specified by the user, it will say "Yes".

What I've done so far is,

Last  Date from Slicer = CALCULATE(MAX( 'Date Slicer'[Date]),ALLSELECTED( 'Date Slicer'[Date]))

After period = IF(DATA[PO Doc Date] >= [First], "Yes","No")

However it seem to not work. Any suggestions?

[amitchandak]

Try After period like

if(calculate(max(DATA[PO Doc Date]),all(DATA)) >= [First], "Yes","No")

[amitchandak]

@syazwan95  , does the above reply helps. if you need more help make me @

Appreciate your Kudos.

[syazwan95]

@amitchandak thanks for the reply. Ive tried it but it doesnt work. still says "yes" for all. I'm wondering if its because of the data/date type.

[v-frfei-msft]

Hi @syazwan95 ,

Your [AB Delv Da] column should be text type, please change it to date to have a check agian.

[syazwan95 · Accepted solution]

@v-frfei-msft it is already a date type.

Okay, so I've made a few changes to it. Instead of using column, I changed it to measure. Seems to work fine.