Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
User | Count |
---|---|
25 | |
11 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
7 |