Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Earliest LAtest date

I would appreciate your help on this one.

Since my data for all markets/retailers is not imported at the same time I have issue with incomplete dates. I would like to keep only days which are earlier than the earliest Latest Date. In other words: I would like that the value 2.6.2019 returns since this is the latest date for which data for all markets/retailers is available.

 

Thank you in advance

 

Latest Date is calculated using MAX() DAX expression

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Anonymous  - I think you would need to summarize the table and then find the min - something like this:

    Your Measure = 
var sum_table = SUMMARIZE(
    'Your Table',
    <Market Column>,
    <Retailer Column>,
    "Latest", MAX(<Date Column>
)
return MINX(sum_table ,[Latest])

    Hope this helps,

    Nathan

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous  - I think you would need to summarize the table and then find the min - something like this:

    Your Measure = 
var sum_table = SUMMARIZE(
    'Your Table',
    <Market Column>,
    <Retailer Column>,
    "Latest", MAX(<Date Column>
)
return MINX(sum_table ,[Latest])

    Hope this helps,

    Nathan

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Anonymous thank you very much for your support - your solution works perfectly.

      Cheers,

      Luka