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
sam_nik12345Hi 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