topic Get the MIN dates from two dates tables in DAX Commands and Tips

Get the MIN dates from two dates tables

Anonymous — Mon, 25 Jul 2022 06:24:50 GMT

Hello folks, hope you all doing great!!

I need a little help with below if someone can))

I have two dates table and I want to get the MIN between them to use it in a slicer.

Background of the issue: I have two tables dates columns and some data, there is a calculation running on both data tables to DIVIDE some values between those tables, the problem is the data entry happens in in different dates and the period is unknown ( manual entry), so I can't use IF date less than 3 days for example to slice, that cuz the calculation to become zeros.

I want my calculation only runs and show data if there is a data in both tables in the same dates
For example:

Prod (first table)	Loss ( in second table)	MIN
14/03/2022	20/03/2022	14/03/2022
20/03/2022	20/03/2022	20/03/2022
20/03/2022	14/03/2022	14/03/2022
14/03/2022	14/03/2022	14/03/2022

how can I get the MIN date column ?

Thanks in advance for your help.

Re: Get the MIN dates from two dates tables

amitchandak — Mon, 25 Jul 2022 07:04:06 GMT

Anonymous , a new column

Date new = Min([Date1], [Date2])

Re: Get the MIN dates from two dates tables

Anonymous — Fri, 29 Jul 2022 08:54:32 GMT

Hi Anonymous ,

Please try below steps:

1.add a index column to two table in Power Query, and then create a mode

2.add a new column “Loss_Table2” in Table

Loss_Table2 = RELATED('Table (2)'[Loss])

3.add a new column “Min_Date” to get the min date between “Prod” and “Loss_table2”

Min_Date = Min('Table'[Prod],'Table'[Loss_Table2])

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.