Forum Discussion

Vnidias's avatar
Vnidias
Regular Visitor
3 years ago
Solved

Max Date from a store visit

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 t...
  • v-yadongf-msft's avatar
    v-yadongf-msft
    3 years ago

    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.

v-yadongf-msft's avatar
v-yadongf-msft
Icon for Community Support rankCommunity Support
3 years ago

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.