SUMMARIZE function for SQL query

[Talaal-Sid]

i want to summarize data from my table , i have come up with following SQL query, how can i implement it with DAX.

SELECT B.ACCOUNT,YEAR(B.DATE) [YEAR],SUM(SALESPRICE) [SUM] FROM SALES B
GROUP BY ACCOUNT,YEAR(B.DATE)

[v-frfei-msft · Accepted solution]

Hi @Talaal-Sid ,

Table = SUMMARIZECOLUMNS(SALESB[DATE].[YEAR],"SUM",SUM(SALESB[SALESPRICE]))