Replicating SQL query in Power BI

Hi Anonymous ,

If you want to create this table in Power BI using direct query you can use this exact SQL statement you only need to use the advance options on the SQL connection and past your SQL code on the window that show for SQL query:

If this is not what you need can you please elaborate better on what you want to achieve and how your model is setup, since there is no direct syntax between SQL and DAX queries

Hi Anonymous 
 MFelix Thanks for the clarification shared above.

Using the SQL statement in the Advanced options with DirectQuery addresses the requirement and preserves the original SQL logic. If the goal differs from this approach, additional details on the model setup and expected output would help clarify next steps.

If you still need assistance, we are happy to assist you or any other new issue you're welcome to start a new thread in the community at any time.

We appreciate your understanding and participation.

Thanks and Regards,
Cheri Srikanth
CST Team.