Forum Discussion
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...
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.
amitchandak
Super User
Super UserAnonymous , a new column
Date new = Min([Date1], [Date2])