Forum Discussion

jainesh12's avatar
jainesh12
Frequent Visitor
3 years ago
Solved

SQL Query to DAX

SELECT customer_id, SUM(amount) AS total_sales FROM orders GROUP BY customer_id; How can I convert it to a DAX function? Is there any AI tool that converts SQL queries to DAX functions? (Except...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi jainesh12 
    If you are creting a measure then simply

    total_sales = SUM ( Orders[Amount] )

    If you want to create a calculated table

    OrdersByCustomer =
SUMMARIZE ( Orders, Orders[Customer_id], "total_sales", SUM ( Orders[Amount] ) )
  • tamerj1's avatar
    tamerj1
    3 years ago

    jainesh12 
    There is no convertor, but you may try asking ChatGPT.

tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi jainesh12 
If you are creting a measure then simply

total_sales = SUM ( Orders[Amount] )

If you want to create a calculated table

OrdersByCustomer =
SUMMARIZE ( Orders, Orders[Customer_id], "total_sales", SUM ( Orders[Amount] ) )
jainesh12's avatar
jainesh12
Frequent Visitor
3 years ago

tamerj1 Thank you for the suggestion.
This was just an example, do you know is their any requirement to convert SQL queries to DAX functions?
If yes, please suggest a few scenarios.

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    jainesh12 
    There is no convertor, but you may try asking ChatGPT.