Reversing Date Axis Matrix

Hi HenryJS ,

For my test ,  to avoid "circle", you could creata a new table using the following formula:

Table 2 =
SUMMARIZE (
    'Table',
    'Table'[Date],
    'Table'[Type],
    'Table'[Value],
    "index", RANKX ( ALL ( 'Table' ), 'Table'[Date],, DESC )
)

Then  select Date column ,sort by Index column, so that  dates in calculated table could be in descending order in Matrix 

Here is the pbix file.

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

Best Regards,
Eyelyn Qin