Power BI - Date Difference

[Navnit]

Hi 

Where is My Mistake that is giving me the below error I cannot get the desired output. 

[SarikaRAJPURE]

You are just missing comma.Put comma instead of dot -> ListOfOrders[New ship date],[Day]

[v-aatheeque]

Hi @Navnit ,

Glad that your query got resolved and If our response addressed by the community member for your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

[v-aatheeque]

Hi @Navnit ,

The answer provided by @Vijay_A_Verma  has resolved your issue? If so, kindly mark the helpful reply as the accepted solution. This will help other community members with similar concerns find solutions more efficiently.
Thank you for your cooperation!"

[v-aatheeque]

Hi @Navnit ,

The answer provided by @Vijay_A_Verma  has resolved your issue? If so, kindly mark the helpful reply as the accepted solution. This will help other community members with similar concerns find solutions more efficiently.

Thank you for your cooperation!"

[Vijay_A_Verma · Accepted solution]

Last parameter in your formula should be DAY not [DAY]

Hence, remove those parenthesis.

Once, you correct it, formula will give right result.

[Navnit]

Thanks, Vijay Sir.....Its working