Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help!!!

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_e...
Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    5 years ago

    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.

     

     

v-angzheng-msft's avatar
v-angzheng-msft
Community Support
5 years ago

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.