Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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's avatar
        Anonymous
        Not applicable
        7 years ago

        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