cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
luka_zz Frequent Visitor
Frequent Visitor

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

 

earliest latest.jpgLatest Date is calculated using MAX() DAX expression

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Earliest LAtest date

@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

View solution in original post

2 REPLIES 2
Super User
Super User

Re: Earliest LAtest date

@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

View solution in original post

luka_zz Frequent Visitor
Frequent Visitor

Re: Earliest LAtest date

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

Cheers,

Luka

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 261 members 2,760 guests
Please welcome our newest community members: