Forum Discussion
DAX And PQ
You 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.
Hi I really appreciate your effort and thank you ever so much for helping, Yeah, I have been moved in recently to build dashboards and the source what they have been using is formula based and cannot make much of a change in it. In this case any other suggestion? Cos the whole data set is depending on formulas of each columns. Other columns are working fine as of now but the today and dates creating havoc.