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.

     

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
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.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    hi v-kalyj-msft,

     

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

    excellent solution

     

    thanks again

     

    regards,

    dsmitha