topic how to only show the earliest orderdate in this case in DAX Commands and Tips

how to only show the earliest orderdate in this case

McFLY — Fri, 03 Jul 2020 02:17:17 GMT

I need some help on this please.

I used a measure called firstOrderDate to calculate the very first order date for each customer it works fine in the first table visual but when I add orderdate column into the second table visual how can I still only show the earliest date and leave the other dates blank for each customer? Thanks.

firstOrderDate = CALCULATE(MIN(FactSales[OrderDate]), ALLEXCEPT(DimCustomer, DimCustomer[FullName]))

Re: how to only show the earliest orderdate in this case

vivran22 — Fri, 03 Jul 2020 02:48:53 GMT

Hello McFLY

What do you mean by leave oter dates blank for each customer? Can you show the sample expected results?

Cheers!
Vivek

Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter

Re: how to only show the earliest orderdate in this case

McFLY — Fri, 03 Jul 2020 04:50:41 GMT

Thank you for your reply.

I mean the third column firstOrderDate in second table I want to always show the earliest date for each customer only.

For example:

Aaron Collins 2011/1/25 0:00:00 2011/1/25 0:00:00

Aaron Collins 2013/11/16 0:00:00 blank

Re: how to only show the earliest orderdate in this case

Anonymous — Fri, 03 Jul 2020 06:57:37 GMT

HI McFLY

Try this measure

First Order Date = VAR a = CALCULATE ( MIN ( FactSales[OrderDate] ), FILTER ( ALL ( DimCustomer ), DimCustomer[FullName] = MAX ( DimCustomer[FullName] ) ) ) RETURN IF ( MAX ( FactSales[OrderDate] ) = a, a, BLANK () )

Regards,

Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!

Re: how to only show the earliest orderdate in this case

McFLY — Mon, 06 Jul 2020 07:36:07 GMT

Thank you Anonymous for your solution.

Re: how to only show the earliest orderdate in this case

Anonymous — Mon, 06 Jul 2020 09:03:32 GMT

Hi McFLY ,

If this solution helps, please mark it as Solved.

Will help others in the community.

Thanks

Harsh Nathani

Re: how to only show the earliest orderdate in this case

Anonymous — Mon, 06 Jul 2020 16:25:16 GMT

[First Order Date] = IF( HASONEVALUE( DimCustomer[FullName] ), CALCULATE( MIN( FactSales[OrderDate] ), ALL( FactSales ), VALUES( DimCustomer[FullName] ) ) )

This code will return the very first order date for any single customer regardless of any other filters that might have been put on any tables.

Best