Forum Discussion
DAX And PQ
Excel data set has a column "Start Date" and column " Vacancy status". There is a formula which is created in excel to extract "Name of the month" in the data set. which is causing an error while ref...
A quick question as the start date column has values like ASAP, Not filled when i change the format its coming as error. Or do u recon just change the format and see where it take to?
aj1973
Community Champion
Community ChampionYou can't change the format of the Start date column to Date. the columns conatins text format like ASAP ! . I don't know the business logic coming from you Excel to really answer your question, all I can tell is that you need to work on your excel file and remove all calculated columns from it in order not have suprises when publishing to the service.