Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
Hi @Medo ,
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.
Hi @Medo ,
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.
@Medo , a new column
Date new = Min([Date1], [Date2])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
44 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
61 | |
50 | |
45 | |
20 | |
17 |