month wise sales

[sam_nik12345]

My table looks like below:

date	sales
2017-07	1
2017-08	1
2017-08	1
2017-08	1
2017-09	1
2017-09	1
2017-09	1
2017-09	1

I want to achieve like below:

date	sales
2017-07	1
2017-08	3
2017-09	4

How can I do so? Kinldy help.

[amitchandak · Accepted solution]

@sam_nik12345 , This seems like a month to me not a date. If this in same format then

Just but this in visual and the put a measure = sum(Table[sales])

If you do not have month you have date create a new column month

Month Year = format([Date], "YYYY-MM")

and use this in visual with sales measure 

Find the file attached after signature

[sam_nik12345]

Hi @amitchandak 

When I visualize this with other tables, it goes back to original state. Both tables are connected with date table and I get below view. Please help me to write a DAX function to resolve this.

date	sales	po
2018-07	2	23
2018-08	34	25
2018-08		23
2018-08		34
2018-09		23
2018-10	12	12

My expected view as below:

date	sales	po
2018-07	2	23
2018-08	34	82
2018-09		23
2018-10	12	12