Forum Discussion
DAX And PQ
your Start Date column is not Date format and can't be, that's why the M code couldn't find the date component in your code.
Can you please show me the out come I might look for a solution on my own. Thanks.
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?
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.