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 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