Creating a DAX Column

[Anonymous]

Hi,

I have the below SQL from which I want to create a column to get the total Collection data for that particular month.

How can I create a DAX calculated column.

select companyid,DATEFROMPARTS(receivedyear,receivedmonth,1) ReceivedMonth,sum(amount) Collection
From CashReceiveds where companyid=280
group by companyid,DATEFROMPARTS(receivedyear,receivedmonth,1)

Expected Output:

companyid	ReceivedMonth	Collection
280	01-01-2019	51823.02
280	01-12-2019	500
280	01-01-2020	90650.48
280	01-02-2020	45903.93

[v-diye-msft · Accepted solution]

Hi @Anonymous 

If the above posts help, please kindly mark it as a answer to help others find it more quickly. thanks!

If not, please kindly elaborate more.

[Greg_Deckler]

@Anonymous No idea about the SQL usually not best path to victory. Sample data is better, but maybe:

New Table = SUMMARIZE('Table',[companyid],[received month],"Collection",SUM([Collection]))

Or if you want a column? Hard to tell, no sample data:

Column = SUMX(FILTER('Table',[companyid]=EARLIER([companyid])&&[received month]=EARLIER([received month])),[Collections])