Self Join in Power BI (without Power Query)

[MrDaniels]

Hi everyone,

Is it possible to create a self join without using Power Query?

For example I'm using a SQL Server Analysis Services DB Cube as datasource.

I have many tables, but just want to do a self join of one table.

For example:

Field A  Field B  Field C

14511   ABC       1234

16333   DEF        1234

What I want is:

Field A1 Field B1 Field C  Field A2  Field B2

14511    ABC       1234      16333     DEF

The self join would be with common Field C.

Can this be done without Power Query? just in the Canvas?

Cheers,

Thanks in advance.

[Uspace87]

@MrDaniels 

The only way is to to do use a "Lookupvale function" but you will have to perform it multiple times. 

Why don't you want to do in Power query?

https://learn.microsoft.com/en-us/dax/lookupvalue-function-dax 

[MrDaniels]

Hi @Uspace87 , thanks for your response.

Already built the report using Power Query, but I'm having an issue trying to refresh the data once I published.

This is the reason Im trying to see if possible without going to power query, cuz currently we are using SQL Server Analysis Cube. I havent been able to use your formula cuz the cube is portected, does not allows me to create columns or transform data if I upload the cube.

Cheers and thanks!