SQL to DAX

[Anonymous]

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

[Anonymous]

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.

Regards,

Pradeep

[Anonymous]

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]

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