Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!