Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all, please for help.
I have two tables,
table A
Table B
I'm looking for formula which will for each Product in Table A find all projects in Table B a put them to column "used in project" as you can see in result Table A
result Table A
Thank you for help
Solved! Go to Solution.
you can also try this
Proud to be a Super User!
you can create a measure
Proud to be a Super User!
thank you,
at real table A and B are much more comlex and PQ cant be used because some important columns are add/modified by dax formulas.
And I need get used projects to table A column, because reasult will be used in slicer.
you can also try this
Proud to be a Super User!
User | Count |
---|---|
98 | |
91 | |
84 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |