Earliest LAtest date

[luka_zz]

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

[Anonymous · Accepted solution]

@luka_zz  - 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

[luka_zz]

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

Cheers,

Luka