Adding custom column is not folding

[Aomran]

Dears,

I'm trying to add a simple custom column just

Table.AddColumn(#"Removed columns", "ComplaintDuration", each Duration.Days([ActualCompletionDate] - [LodgementDate]))

But this is not folding! It's not something copmlex in M langauge! Can someone please help me to fold this or do it in another way?

Thanks

[v-prasare]

Hi @Aomran,
Thanks for reaching MS Fabric community support

In this case please consider raising a support ticket for further assistance. To raise a support ticket with Fabric and Power BI, kindly follow the steps outlined in the following guide:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

Thanks,

Prashanth Are

[v-prasare]

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.

[Aomran]

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

[v-prasare]

@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

[v-prasare]

@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

[v-prasare]

@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

[OwenAuger]

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?