Forum Discussion

Navnit's avatar
Navnit
New Member
1 year ago
Solved

Power BI - Date Difference

Hi 

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

 

 

 

 

 

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

    Hence, remove those parenthesis.

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

6 Replies

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Most Valuable Professional

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

    Hence, remove those parenthesis.

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

    • Navnit's avatar
      Navnit
      New Member

      Thanks, Vijay Sir.....Its working

  • v-aatheeque's avatar
    v-aatheeque
    Community Support

    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's avatar
      v-aatheeque
      Community Support

      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's avatar
        v-aatheeque
        Community Support

        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!"

  • SarikaRAJPURE's avatar
    SarikaRAJPURE
    Frequent Visitor

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