Forum Discussion
Helper IImonth wise sales
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
Super Usersam_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
Helper IIHi 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 |