How to compare & get the lowest value of 2 columns in different table?

[BalazsNy]

Hi!

I have 2 tables including Product ID / Product / Sold date (1 / 2). These tables have 1:1 relationship based on Product ID. I would like to build up a table visual including Product ID / Product / First sold date (comparing sold date of Table1 & Table2).

I would like to get the below result (TableOveral):

Could you please advise a DAX formula to solve this?

Thanks in advance!

[Ashish_Mathur]

Hi,

Enausre that the 3 columns are spelled the same way in both tables.  In the Query Editor, append the 2 tables.  Create your visual from the appended table.  Write this measure

First date = min(appendedtable[Date])

Hope this helps.

[littlemojopuppy]

Didn't @Ahmedx solve this three hours earlier?

[Ahmedx]

or you can wirt this

Measure = MIN(MIN('Table1'[Sold datel]),MIN('Table2'[Sold date_2]))

[BalazsNy]

Thanks. It is almost perfect, but there are some rows when only one of the tables contains sold date, in the other table it is emtpy (so its value is 0). In that case, overall table should contain the existing date, not 0.

[Ahmedx · Accepted solution]

pls try this

Measure = 
VAR _date1 = MAX('Table1'[Sold datel])
VAR _date2 = MAX('Table2'[Sold date_2])
RETURN
SWITCH( TRUE(),
    ISBLANK(_date1) ,_date2,
    ISBLANK(_date2), _date1 ,
MINX({MIN('Table1'[Sold datel]),MIN('Table2'[Sold date_2])},[Value]))

[BalazsNy]

Thanks, but finally a managed to solve it with the following calculated column in Table1:

First_sold_date =

VAR date1 = Table1[Sold_date_1]

VAR date2 = RELATED(Table2[Sold_date_2])

RETURN

if(

    ISBLANK(date1)=ISBLANK(date2),

    MIN(date1,date2),

    MAX(date1,date2)

    )

[Ahmedx]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

https://1drv.ms/u/s!AiUZ0Ws7G26RixkU7pqZfn8MqTEW?e=sgdCFM