Max Date from a store visit

[Vnidias]

Hello guys i´m with case that i have a date used in modelling of a store.

My main problem is i need to create a measure that depends from a max date per month 

ex:

For that example in that store, i should have a measure bring me the max date of that visit. In the example 24-10-2022

the problem is i cant use a calculated column to solve this situation, i should do using just a measure.

Someone could give me a light on this?

[Vnidias]

Guys thanks for the help!

[wdx223_Daniel]

Measure=CALCULATE(MAX(FactTable[Date]),ALLEXCEPT(FactTable,Factable[StoreID]))

[v-yadongf-msft · Accepted solution]

Hi @Vnidias ,

This is my date table:

Another table:

Relationship between two tables:

Create a measure:

Measure = CALCULATE(MAX('Date'[Date]),FILTER(ALL('Table'),'Table'[Attribute] = SELECTEDVALUE('Table'[Attribute])))

You will get the max date of that visit

Best regards,

Yadong Fang

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