comparation in monthly bassis using slicer and table

[Anonymous]

Hi all, Im new begginer in power bi, so I need to help make the report for this

I have a table which is showing my store moving below:

Date	Project	Store Name	Store Location X	Store Location Y
8-Oct-17	bramakumbara	BRA1	9740205.8	621271.19
8-Oct-17	bramakumbara	BRA2	9738208.1	622354.3
8-Oct-17	mantili	UBI1	9712533.62	574125.17
8-Oct-17	mantili	UBI2	9714590.4	571432.7
8-Oct-17	mantili	UBI3	9708478.1	569606.1
9-Sep-17	mantili	UBI1	9712533.62	574125.17
9-Sep-17	mantili	UBI2	9714560.4	571432.7
9-Sep-17	mantili	UBI3	9709478.1	569606.1
9-Sep-17	bramakumbara	BRA1	9840205.8	621681.18
9-Sep-17	bramakumbara	BRA2	9838208.1	627354.3

with this table i need to show comparation (X,Y)location in monthly bassis ( sept compare with Oct... Oct compare with Nov.. so on..), would guys help to make this in the power bi ( using slicer and table)?., so i can see my store moving

Regards,

KML

[amitchandak]

Can you try

Last Year MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date Filer],-12,MONTH)))

Last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date Filer]))

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
Thanks.

[Anonymous]

could you please show me how to doit ( slicer with matrix table)

so i can folow it.

thanks for your kind

Regards,

-KML-