Adding custom column is not folding

Hi Aomran 

Is your data source SQL Server or similar?

This works for me:

Table.AddColumn(#"Removed columns", "ComplaintDuration", each Number.From([ActualCompletionDate]) - Number.From([LodgementDate]), Int64.Type)

Does this work for you?

Aomran,  As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by our super user helps? or let us know if you need any further assistance here?

OwenAuger, Thanks for your promt response

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

Aomran, As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by our super user helps? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

Aomran As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by our super user helps? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

Hi all, my data source is Odata! The issue is still there, once I need to add a cutome column.

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

If we don’t hear back, we’ll go ahead and close this thread. For any further discussions or questions, please start a new thread in the Microsoft Fabric Community Forum  we’ll be happy to assist.

Thank you for being part of the Microsoft Fabric Community.

We are following up once again regarding your query. Could you please confirm if the issue has been resolved through the support ticket with Microsoft?

If the issue has been resolved, we kindly request you to share the resolution or key insights here to help others in the community. If we don’t hear back, we’ll go ahead and close this thread.

Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

Thank you for your understanding and participation.