Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Month on month comparison

Hi,   Raw data: Date                Sales     Customer name 25-07-2020       500      Pavan 26-07-2020       800     suresh 27-07-2020       1000    sai 28-07-2020        500    naresh 01-06-...
Need Help
v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
6 years ago

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.

 

 
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!