topic I need your help with DAX in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/I-need-your-help-with-DAX/m-p/3389706#M127768 <P>dear community&nbsp;</P><P>may you help me with a DAX formula that calculte the (&nbsp;difference days ) automatically as in the table bellow</P><TABLE><TBODY><TR><TD>Start</TD><TD>End</TD><TD>Difference days</TD></TR><TR><TD>23-Apr-23</TD><TD>25-Apr-23</TD><TD>1</TD></TR><TR><TD>1-May-23</TD><TD>3-May-23</TD><TD>1</TD></TR><TR><TD>4-Jun-23</TD><TD>7-Jun-23</TD><TD>2</TD></TR><TR><TD>17-Jun-23</TD><TD>19-Jun-23</TD><TD>1</TD></TR></TBODY></TABLE> Mon, 21 Aug 2023 09:20:24 GMT haniizz 2023-08-21T09:20:24Z I need your help with DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/I-need-your-help-with-DAX/m-p/3389706#M127768 <P>dear community&nbsp;</P><P>may you help me with a DAX formula that calculte the (&nbsp;difference days ) automatically as in the table bellow</P><TABLE><TBODY><TR><TD>Start</TD><TD>End</TD><TD>Difference days</TD></TR><TR><TD>23-Apr-23</TD><TD>25-Apr-23</TD><TD>1</TD></TR><TR><TD>1-May-23</TD><TD>3-May-23</TD><TD>1</TD></TR><TR><TD>4-Jun-23</TD><TD>7-Jun-23</TD><TD>2</TD></TR><TR><TD>17-Jun-23</TD><TD>19-Jun-23</TD><TD>1</TD></TR></TBODY></TABLE> Mon, 21 Aug 2023 09:20:24 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/I-need-your-help-with-DAX/m-p/3389706#M127768 haniizz 2023-08-21T09:20:24Z Re: I need your help with DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/I-need-your-help-with-DAX/m-p/3389725#M127769 <P>Hi</P><P>&nbsp;</P><P>Use DATEDIFF(start,end,DAY)</P> Mon, 21 Aug 2023 09:28:09 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/I-need-your-help-with-DAX/m-p/3389725#M127769 Semaj06 2023-08-21T09:28:09Z Re: I need your help with DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/I-need-your-help-with-DAX/m-p/3389730#M127770 <P>Hi Semaj</P><P>&nbsp;</P><P>may you help me with furthur explanation?</P> Mon, 21 Aug 2023 09:30:19 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/I-need-your-help-with-DAX/m-p/3389730#M127770 haniizz 2023-08-21T09:30:19Z Re: I need your help with DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/I-need-your-help-with-DAX/m-p/3389779#M127773 <P><img /></P><P>&nbsp;</P> Mon, 21 Aug 2023 09:46:43 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/I-need-your-help-with-DAX/m-p/3389779#M127773 Semaj06 2023-08-21T09:46:43Z Re: I need your help with DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/I-need-your-help-with-DAX/m-p/3389787#M127774 <P>Thank you so much Semaj</P> Mon, 21 Aug 2023 09:50:37 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/I-need-your-help-with-DAX/m-p/3389787#M127774 haniizz 2023-08-21T09:50:37Z