Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Expression error in one column and not the other

Hello all,   I have the following query in one column. The "Late" status is the only  status that populates errors within the column (Red font). The error states : Expression.Error: We cannot conve...
Need Help
edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
5 years ago

I'd have to see some sample data. There are on obvious issues in the code, but I also don't understand why you have two columns with these names - "Actual Initial 3 - Week Review #", "Actual Initial 3 - Week Review" - may be totally legit, just seems weird - but I also don't understand your data like you do. 

How to get good help fast. Help us help you.

How To Ask A Technical Question If you Really Want An Answer

How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Edhans, 

     

    The reason I have the two columns is that  "Actual Initial 3 - Week Review #" is formated as text therefore I replaced all null values with N/A , "Actual Initial 3 - Week Review" is formated as a date. Same data, just different format. I agree it is strage, but it was my own way of trying to get the code to work. Essentially the data I am trying to compare are date fields. 

    • edhans's avatar
      edhans
      Icon for Community Champion rankCommunity Champion
      5 years ago

      Understood Anonymous - still need data here to troubleshoot. Links above for guidance on that.