Auto disappear from table visual after contract end date

[Anonymous]

Hi,

Request your guidance regarding this issue;

I have a table visual in which contract end date of employees are displayed.  one column ( contenddate) shows the last working day of employee in date format . Next to that is a column ( status) which displays whether it is terminated/resigned/retired .  For these  three cases once the last working day is over ( say 10th August 2022) then this record should not be displayed in the visual. is there any way to make this happen.  ( i dont want to make any change in the database - xls table )

kindly advice

regards,

dsmitha

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ,

According to your description, in my understanding you want the contract end date which is over not display in the visual, you can create a measure.

Check =
IF ( MAX ( 'Table'[Contract end date] ) > TODAY (), 1, 0 )

Then put the measure in the visual filter and select its value to 1.

After apply filter, get the correct result, the date(2022/8/10) is filtered out.

I attach my sample below for your reference.

Best Regards,
Community Support Team _ kalyj

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

[Anonymous]

hi v-kalyj-msft,

thanks a ton ! this is exactly what i was looking for

excellent solution

thanks again

regards,

dsmitha

[rsbin]

@Anonymous ,

Select your Table Visual.

Then in the Filter Pane, under "Status", deselect the 3 values ( terminated/resigned/retired ) that you do not want to show up.

[Anonymous]

Hi rsbin,

Thank you for your suggestion but am afraid that i didnt make it clear in my request . Instead of applying the filter I would like to make this happen with a DAX .   Contract end date of employees are different so whenever the date today = contract end date then that record should not be displayed

 

regards,

dsmitha

 

 

PREVIEW