Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Get the MIN dates from two dates tables

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/202220/03/202214/03/2022
20/03/202220/03/202220/03/2022
20/03/202214/03/202214/03/2022
14/03/202214/03/202214/03/2022


how can I get the MIN date column ?

Thanks in advance for your help. 

DAX
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.