Forum Discussion
Error while adding Custom Column in Power Query
Hi sureshrawat048, Hope your issue is solved. If it is, please consider marking the answer 'Accept as solution', so others with similar issues may find it easily. If it isn't, please share the details.
Thank you.
Super UserI believe you are using Power Query in Excel. What is the result of this custom column in Power Query data preview? is there any error? if yes then please share the error message. If you are not able to see the error in the preview that does not mean there are no errors, by default power query profiles only 1000 rows, So I would suggest you to click on "Keep Errors" transformation and find the error message.
I am guessing Date.FromText could be a possible reason for the errors. If Power Query cannot parse it as a proper date then it can through an error. You need explictly mention the format. For example
Date.FromText( "2023-31-12", [Format="yyyy-dd-M" ] )
https://powerquery.how/date-fromtext/
Please share the error message for further assistance
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
|
Hi, Error :
Expression.Error: We cannot convert the value null to type Logical.
Details:
Value=
Type=[Type]
- tharunkumarRTK
This error message suggests that you have a column with null values and you are using it as logical value (TRUE/FALSE) in an expression.
Handle this exception and see it that helps
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!