Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Auto disappear from table visual after contract end date

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 emplo...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    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.

     

rsbin's avatar
rsbin
Icon for Community Champion rankCommunity Champion
4 years ago

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's avatar
Anonymous
Not applicable
4 years ago
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