Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
dnowebdn
Contributor
Contributor

not right

Hi team,

Could you please look into the below

2 Replies
dnowebdn
Contributor
Contributor
Author

any help

qliknerd
Contributor III
Contributor III

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);