Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

SQL to DAX

Can anyone help in converting the sql query to DAX for creating measures in power BI

select R.*
from APPS S
left Join APPREVIEW R on S.appname = R.appname
where S.appname = 'CANDY'
and R.appvalues > 50000
order by R.appvalues desc

3 REPLIES 3
Anonymous
Not applicable

Hi Roshawna,

 

You can use the same query in Advanced Editor to get this result. Since, PBI doesn't support left outer join to fetch the data based on left outer join.

 

SQL Query Advanced Editor in PBI.PNG

 

Regards,

Pradeep

Anonymous
Not applicable

Hi @Anonymous I don't have the access to get the data using Advanced Editor , though I am working with the already published reports.

Is there any other way.

Anonymous
Not applicable

Hi Roshawna,

 

This is also possible in DAX.

 

By using NATURALLEFTOUTERJOIN([APPS],[APPREVIEW])   you can do the left outer join query in DAX to get all the records from table 1 "APPS" and Matching records with table 2 "APPREVIEW".

 

Then, you can apply more filters on the Transformations or using Filters in Power BI.

 

Regards,

Pradeep

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.