Help!!!

[Anonymous]

Greetings!

I have one SQL query which creates a table.
Query is -

Select a.origin_date, a.consumer_level, a.id as Cust_id, b.id from
vw_ratio as a
full join vw_ratio as b
on a.id = b.cust_emp_id
and a.origin_date = b.origin_date

In sql they are doing self join i guess.

I am wondering how can i do it powerBi!
Can anyone suggest me on this??

[v-angzheng-msft · Accepted solution]

Hi, @Anonymous 

I am not very sure what you mean, do you just want to get the table or do you want to reproduce the functionality of this SQL statement in Power BI for learning purposes. Be aware that SQL statements are also available in Power BI.

If you want to reproduce the function of this sql statement, you can try to create calculate table like below:

Of course, merging in Power query is also helpful. I'm not sure what your exact requirements are so I provide as much relevant information as possible, hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , In power query, merge you have the option of full join merge

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

[Anonymous]

@amitchandak , for that Sql query i have to do full join merge?

Instead of mergering Can we write dax?