not right

[dnowebdn]

Hi team,

Could you please look into the below

[dnowebdn]

any help

[qliknerd]

Your YearMonth column is text. Try using the Dual function which will allow you to sort it by the numerical value:

tests:
LOAD
  *,
  Dual("Year" & '-' & "Month", Date) as YearMonth;

LOAD
    SalesAmnt,
    Type,
    Month,
    Year,
    Date(Date#('01/' & Month & '/' & Year, 'dd/MMM/yyyy')) as Date
FROM [lib://folder/RSA Test.xlsx]
(ooxml, embedded labels, table is Sheet1);