Forum Discussion
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.appval...
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
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.
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