Forum Discussion

vhugozg's avatar
vhugozg
Frequent Visitor
4 years ago

Filter date by last date from another table

Hi everyone,   I'm trying to filter a table related to the last date from another one. These dates can't have a direct relation, so I tried to create measures, calculated columns, and much more to ...
Need Help
v-xiaotang's avatar
v-xiaotang
Community Support
4 years ago

Hi vhugozg 

Hi @vhugozg 

Try this, create the measures

Calendar Ultima Data = CALCULATE(MAX('Calendar'[Date]),ALLSELECTED('Calendar'))
CadastroMenorQue = IF(MIN(InativosDatas[Data de cadastro])>[Calendar Ultima Data],FALSE(),TRUE())

 

 

Best Regards,

Community Support Team _Tang

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

vhugozg's avatar
vhugozg
Frequent Visitor
4 years ago

Hi v-xiaotang , thank you for the reply.
I tried exactly as you said, but stills the same behavior. I can't understand what is happening with PBI.

I also remake my table with a measure just to see how it would work.

 

It make no sense to me that the table show two dates, compare it, and shows incorrect values.



  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    Hi vhugozg 

    Also confused about this, I haven't encountered it before, could you provide a sample file with this issue for us to test? thanks, curious about the reason for this behavior.

     

     

    Best Regards,

    Community Support Team _Tang

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