Forum Discussion

kkishba2's avatar
kkishba2
Icon for Helper I rankHelper I
1 year ago
Solved

In Need of Help to Convert SQL statement to DAX

I am new to Power BI and DAX.  I need assistance converting (learning how to convert) a SQL statement to DAX. The statement below is useful extracting against SSMS, but we have a Semantic Model which...
  • SachinNandanwar's avatar
    SachinNandanwar
    1 year ago

    Thats great but unforutanetly at the first sight the SQL query looks to complicated to be converted to DAX .There are 4 tables involved with multiple joins with to many predicates.If its me I would stick to SQL View approach.

     

    But if you still would like to try the DAX way, then post the semantic model,the business rules and the sample data here.