Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
My code:
Solved! Go to Solution.
NATURALINNERJOIN as per documentation
Columns being joined on must have the same data type in both tables.
Only columns from the same source table (have the same lineage) are joined on. For example, Products[ProductID], WebSales[ProductdID], StoreSales[ProductdID] with many-to-one relationships between WebSales and StoreSales and the Products table based on the ProductID column, WebSales and StoreSales tables are joined on [ProductID].
https://docs.microsoft.com/en-us/dax/naturalinnerjoin-function-dax
Refer how to use : https://www.youtube.com/watch?v=mcQ_ZmuWvDs&vl=en
there is a costly option
filter(crossjoin(table1,table2), Table1[A]=Table2[B])
Try in edit query
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
NATURALINNERJOIN as per documentation
Columns being joined on must have the same data type in both tables.
Only columns from the same source table (have the same lineage) are joined on. For example, Products[ProductID], WebSales[ProductdID], StoreSales[ProductdID] with many-to-one relationships between WebSales and StoreSales and the Products table based on the ProductID column, WebSales and StoreSales tables are joined on [ProductID].
https://docs.microsoft.com/en-us/dax/naturalinnerjoin-function-dax
Refer how to use : https://www.youtube.com/watch?v=mcQ_ZmuWvDs&vl=en
there is a costly option
filter(crossjoin(table1,table2), Table1[A]=Table2[B])
Try in edit query
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Not a complete answer, but it was enough to get me moving in the right direction.
Ok, So I made it a step further... almost what I need, code below:
That function can be rather tempermental. Would need source data to try to replicate:
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |