Month on month comparison

Hi, 

Try using the Matrix visualization with the following: 

- Rows: Customer name

- Columns: Date (month)

- Value: Sales

Anonymous , Try like. You need two date table, both have month year in that. Keep slicer from each one .

measure1 =
var _min = minX(allselected(Date,Date[Date]))
var _max = manX(allselected(Date,Date[Date]))
return
calculate(sum(Table[Sales]), filter(Table,Table[Date]>=_min && Table[Date]<=_max))

Use the crossfilter is Date is joined and active.

measure2 =
var _min = minX(allselected(Date1,Date1[Date]))
var _max = manX(allselected(Date1,Date1[Date]))
return
calculate(sum(Table[Sales]), filter(Table,Table[Date]>=_min && Table[Date]<=_max))
//calculate(sum(Table[Sales]), filter(Table,Table[Date]>=_min && Table[Date]<=_max), crossfilter(Table[Date],Date[Date],none))

Here is a copy using your data 

PBIX 

Hi Anonymous ，

First create a column as below:

Month = FORMAT('Table'[Date],"mmmm")&" "& "dates sales"

Then put the Month in the column field of a matrix and you will see：

For the related .pbix file,pls see attached.