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.
Hi,
I Have two tables, where table A has unique values and tables B(dynamically updated) will always contain a few records from table A. Table A
Table B
When I do UNION, I get duplicate rows.
I have also tried using
Solved! Go to Solution.
@Anonymous
This is because open High, low values has some diff.
Use Summarize and take min and max of that
Try like
summarize(UNION(VALUES('Table 2'),VALUES('Table 1')),[Date],"Open",max([Open]),"Low",min([Low]),"High",max([High]))
@Anonymous
This is because open High, low values has some diff.
Use Summarize and take min and max of that
Try like
summarize(UNION(VALUES('Table 2'),VALUES('Table 1')),[Date],"Open",max([Open]),"Low",min([Low]),"High",max([High]))
UNION in DAX is the same as UNIONALL in SQL. Wrap the whole thing inside DISTINCT()
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 |
---|---|
103 | |
102 | |
87 | |
73 | |
67 |
User | Count |
---|---|
119 | |
111 | |
95 | |
79 | |
72 |