How to perform Cross Join between two columns with little bit different approach

codingenthu — Fri, 17 Nov 2023 00:33:02 GMT

I have 2 columns from two different tables as below:

Table1:

size

Table2:

unit

Desired Output:(New Calculated Table)

size	unit
1	50
2	50
2	49
3	50
3	49
3	48
4	50
4	49
4	48
4	47

So based on size value(number) from the Table1, the top values should return in new rows for example: if size value is 3 then top 3 values, if it is 4 then top 4 values and so on..

Can somebody please help on how can i achieve this in DAX?

Re: How to perform Cross Join between two columns with little bit different approach

vicky_ — Fri, 17 Nov 2023 01:34:51 GMT

Here's my attempt:

New Table = var crossjoined = CROSSJOIN(unit, size) var toReturn = FILTER(crossjoined, [size] >= RANK(unit, ORDERBY([unit], DESC))) return toReturn

topic Re: How to perform Cross Join between two columns with little bit different approach in DAX Commands and Tips

How to perform Cross Join between two columns with little bit different approach

Re: How to perform Cross Join between two columns with little bit different approach