Marix Visual - Sorting by desc order

[Puvvula12]

I have a requirement where I am using Matrix visual, I have to show column total on left side and most recent date on left (Descending order). Is there is way to achieve this? 

Data: 

ID	Account Name	City	State	Sales	Invoice date
1	A	TX		100	1/24/2023
2	B	PA		200	2/25/2023
3	C	OK		300	1/24/2023
4	c	OK		500	2/25/2023
5	B	PA		700	3/26/2023
6	A	TX		200	2/25/2023

 Expected table : 

ID	Account Name	City	State	Total Sales	Mar	Feb	Jan
1	A	TX		300	100	200
2	B	PA		900	200		700
3	C	OK		800	300	500

[Andregewehr]

Hello,

Have you tried to make a measure using filter by month? I think you can use these measures:

Sum Sales Jan = CALCULATE(Sum('Table'[Sales]), MONTH('Table'[Invoice date])=1)
Sum Sales Fev = CALCULATE(Sum('Table'[Sales]), MONTH('Table'[Invoice date])=2)
Sum Sales Mar = CALCULATE(Sum('Table'[Sales]), MONTH('Table'[Invoice date])=3)

 But I think your expected table gives wrong numbers, check it. I guess you should expect this:

[Puvvula12]

Thank you for your quick response.

Sorry for not mentioning it earlier, I have to show daily, weekly and Monthly report separately.  How can I show daily sales (365 days) in descending order (most recent date in left to right)?

[Andregewehr]

Can you show the expected results you want?

[Puvvula12]

Hi Andregewehr, 

Thanks for looking into it. 

Here is the expected results in 

Daily Sales in Q4 - Dec-Oct: 

ID	Account Name	City	State	Total Sales	12/31/2022	12/30/2022	12/29/2022	10/1/2022
1	A	TX		300	100	200
2	B	PA		900	200		700
3	C	OK		800	300	500

Weekly Sales in Q4 (start of the week):

ID	Account Name	City	State	Total Sales	26-12-2022	19-12-2022	12/12/2022
1	A	TX		300
2	B	PA		900
3	C	OK		800

Monthly Sales in Q4

ID	Account Name	City	State	Total Sales	Dec	Nov	Oct
1	A	TX		300	100	200
2	B	PA		900	200		700
3	C	OK		800	300	500