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.
Need help trying to solve this problem.... im bringin data to a table A from another related table B.
Eg:
Table B
31/04/2024 Blue
22/03/2024 Blue
05/02/2024 Red
03/02/2024 Blue
I need to get the MIN date for BLUE (before iterating to Red) in this case should get 22/03/2024.
Any idea??
Solved! Go to Solution.
Hi, You can create a relationship between the 2 tables based on your color column.
For demo, I created 2 sample tables:
then create a join between these 2 using color column.
then create the below measure:
Hope this helps to resolve your problem. If it does, then please mark it as solution, thanks!
Hi, You can create a relationship between the 2 tables based on your color column.
For demo, I created 2 sample tables:
then create a join between these 2 using color column.
then create the below measure:
Hope this helps to resolve your problem. If it does, then please mark it as solution, thanks!
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |