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 all,
I am pretty new and can not find my solution in the other posts.
Can you please help me?
I will try to explain (probably harder then the solution 🙂 )
I have 2 tables:
Table A | ||
Number | Description | Season 1 |
1 | Jacket | summer |
2 | Jacket | spring |
3 | Trouser | spring |
4 | Hat | summer |
Table B | ||
Order | Description | Season |
1 | Jacket | |
2 | Jacket | |
3 | Trouser | |
4 | Hat |
When:
[Number] from Table A = [Order] from table B
AND
[Description] from Table A = [Description] from table B
Then column "Season" from table B must be filled in by column "Season 1", table A.
The "Numbers" and "Orders" are unique and have the relation many-to-one.
Has anyone an idea?
Thank you!
Solved! Go to Solution.
Hi @LogiFons
You can refer to the following calculated column
Season = MAXX(FILTER('Table A',[Number]=EARLIER('Table B'[Order])&&[Description]=EARLIER('Table B'[Description])),[Season 1])
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @LogiFons
You can refer to the following calculated column
Season = MAXX(FILTER('Table A',[Number]=EARLIER('Table B'[Order])&&[Description]=EARLIER('Table B'[Description])),[Season 1])
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello,
Sorry, i am mistaking.
In Table A, the column Number is not always unique.
In Table B, the column Order is unique.
Table A | ||
Number | Description | Season 1 |
1 | Jacket | summer |
2 | Jacket | spring |
3 | Trouser | spring |
4 | Hat | summer |
Table B | ||
Order | Description | Season |
1 | Jacket | |
2 | Jacket | |
3 | Trouser | |
4 | Hat |
Gr,
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |