Forum Discussion
Month column not properly formatted
Hi, I have monthly data imported for 10 months from 10 excel sheets from which the Month was extracted from the file names using "Text between Delimiters", the data type of the Month column is te...
amitchandak
Super User
Super UserAnonymous , Make them a date column
Date = "01-" & left([Month],3) & "-" & right([Month],2)
Mark that as date , then try
Date new= date(year([Date])+1,month([Date]),Day([Date]))
Hi amitchandak ,
I believe the solution suggested by you is with DAX. Is there any way to do it in the Query Editor itself before loading the data?
Regards,
Vishy