Forum Discussion

MrDaniels's avatar
MrDaniels
Frequent Visitor
3 years ago

Self Join in Power BI (without Power Query)

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.

 

 

Need Help

2 Replies

    • MrDaniels's avatar
      MrDaniels
      Frequent Visitor
      3 years ago

      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!