Solved: SUMMARIZE function for SQL query

Talaal-Sid · ‎04-04-2019

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 · ‎04-07-2019

Hi @Talaal-Sid ,

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

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

v-frfei-msft · ‎04-07-2019

Hi @Talaal-Sid ,

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

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.