showing the max date in one dim date on another dim date

[DanielS_Waves]

Hi all,

I have two DimDate tables for a sales comparison.
I want to see the max date in DimDate1 after using filter visual and to be able to see it in the other DimDate2

what I get is the max date of DimDate1 without the filter

Here are some photos for more explanation:

any suggestions?

[Anonymous]

Hi @DanielS_Waves ,

I don't quite understand your needs , please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

Best Regards,

Neeko Tang

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

[DanielS_Waves]

I managed, I found another solution for what I was looking for.
Thanks!

[Anonymous]

Hi @DanielS_Waves ,

It's nice to know that your problem has been solved and you can mark the answer as a solution to help more people. Thank you.

Best Regards,

Neeko Tang

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

[DanielS_Waves]

which answer do you want me to mark?
There is no solution here..

[Anonymous]

Hi @DanielS_Waves ,

I'm sorry I didn't express my meaning correctly.I mean could you share the solution and tag it to help more people solve similar problems, thanks in advance.

Best Regards,

Neeko Tang

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

[DanielS_Waves]

First, I did something else to achieve what I needed for the report, with bookmarks, so it's not quite the solution for the described problem
But I can upload some PBIX file for what I did if that's helpful. how do I do that? didn't notice that option