Take MAXDate from slicer date between

[Astrid_M-vB73]

Hi,

I am working with an AAS model in PowerBI and I would like to do the following:

I have a date slicer based on dates between.

The graph on the right reflects numbers for the period based on the dates between selected in the slicer. So this one is fine.

But the left matrix should only reflect numbers per month and this should always be the max month that is selected in the slicer.

What is the Dax formula that I could use the show the max month data in the matrix on the left?

Many thanks in avance for your help.

Regards,

Astrid 

[Icey · Accepted solution]

Hi @Astrid_M-vB73 ,

Have you tried to add a visual filter on the left matrix like below?

Best Regards,

Icey

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

[Astrid_M-vB73]

What a brilliant solution!

I was so focused on the fact that I thought this could only be solved with a DAX formula, that I forgot there are other ways to filter the data. Great!

Many thanks for your help.

Regards,

Astrid

[VahidDM]

Hi @Astrid_M-vB73 

You need to create a measure and use MAX and FILTER.

Can you share a sample of your data in a table format?

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

Appreciate your Kudos!!

[Astrid_M-vB73]

Thank you for your quick reply!

I have tried to clarify my issue by creating this picture.

Hope this helps.