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 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?

 

 

 

 

  • 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.

3 Replies

  • 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.

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Icon for Community Champion rankCommunity Champion
    3 years ago

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