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 th...
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.

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.