cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ivyhai Member
Member

DAX to pick up Earlyest Date

I would like to add a column to show the earliest date from A B C D columns. (See below)  

 

PBI.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: DAX to pick up Earlyest Date

Hi @ivyhai

Try the following, where Table1 is the name of your table:

 

NewColumn =
MIN ( Table1[A], MIN ( Table1[B], MIN ( Table1[C], Table1[D] ) ) )

 

2 REPLIES 2
Super User
Super User

Re: DAX to pick up Earlyest Date

Hi @ivyhai

Try the following, where Table1 is the name of your table:

 

NewColumn =
MIN ( Table1[A], MIN ( Table1[B], MIN ( Table1[C], Table1[D] ) ) )

 

Super User
Super User

Re: DAX to pick up Earlyest Date

Hi,

 

In the Query Editor, right click on the first column and select "Unpivot other columns".  Ensure that the data type of the Value column is Date.  Drag Contact ID to the Table visual and add this measure

 

=MIN(Data[Value])

 

Format the measure as a Date.