Add Months in table - please help

[wanass123]

Hello everyone , 

I have data in the below table : 

Amount Paid	PaymentDate
322	9-Aug-22
131	2-Sep-22
212	2-Oct-22
200	20-Aug-22
113	8-Aug-22

and I need to extend the table and  add Month when payment was done example : 

Amount Paid	PaymentDate	October	September	August
322	9-Aug-22			322
131	2-Sep-22		131
212	2-Oct-22	212
200	20-Aug-22			200
113	8-Aug-22			113

please help 

[OmarBenSalem · Accepted solution]

load
AmountPaid,
date(date#(PaymentDate,'D-MMM-YY')) as PaymentDate,
Month(date#(PaymentDate,'D-MMM-YY')) as PaymentMonth
Inline [
AmountPaid, PaymentDate
322, 9-Aug-22
131, 2-Sep-22
212, 2-Oct-22
200, 20-Aug-22
113, 8-Aug-22

Create a pivot table : 

Lines : AmountPaid, PaymentDate

Column : PaymentMonth

Measure: sum(AmountPaid)

];

uncheck this in the presentation :