https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-to-calculate-date-difference-in-power-bi-dax/m-p/2712199#M82439 <P>Hi PBI Experts ,</P><P>I&nbsp;Need to calculate date difference in power bi dax but i am getting error could you please suggest.</P><P><img /></P><P>&nbsp;</P> Fri, 19 Aug 2022 09:54:05 GMT Mahamood0218 2022-08-19T09:54:05Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-to-calculate-date-difference-in-power-bi-dax/m-p/2712199#M82439 <P>Hi PBI Experts ,</P><P>I&nbsp;Need to calculate date difference in power bi dax but i am getting error could you please suggest.</P><P><img /></P><P>&nbsp;</P> Fri, 19 Aug 2022 09:54:05 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-to-calculate-date-difference-in-power-bi-dax/m-p/2712199#M82439 Mahamood0218 2022-08-19T09:54:05Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-to-calculate-date-difference-in-power-bi-dax/m-p/2712302#M82441 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="360382" data-lia-user-login="Mahamood0218" class="lia-mention lia-mention-user">Mahamood0218</a> , If you are creating a measure </P> <P>&nbsp;</P> <P>averagex(Table, Quotient( datediff([Start Date], [EndDate],Month),12) )</P> Fri, 19 Aug 2022 10:26:19 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-to-calculate-date-difference-in-power-bi-dax/m-p/2712302#M82441 amitchandak 2022-08-19T10:26:19Z