https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/EDATE/m-p/3119201#M110551 <P>If it's a measure you want, you will need aggregations in front of each column.</P> <P>I suggest you experiment with the EDATE part removed and just get 'the number of months' on a visual to test.</P> <P>Also I don't follow the accuracy of the provided Order Date column. Can you explain how you got that?</P> Wed, 08 Mar 2023 15:15:43 GMT HotChilli 2023-03-08T15:15:43Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/EDATE/m-p/3118755#M110506 <P>I am trying to use a subtract measure to form the months part of the EDATE function, this number can vary depending on whats in the other columns. For example, I'm trying to work out when to purchase the product, so I'm minusing Lead Time from Stock on Shelf</P> Wed, 15 Mar 2023 10:29:37 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/EDATE/m-p/3118755#M110506 Digger99 2023-03-15T10:29:37Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/EDATE/m-p/3119201#M110551 <P>If it's a measure you want, you will need aggregations in front of each column.</P> <P>I suggest you experiment with the EDATE part removed and just get 'the number of months' on a visual to test.</P> <P>Also I don't follow the accuracy of the provided Order Date column. Can you explain how you got that?</P> Wed, 08 Mar 2023 15:15:43 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/EDATE/m-p/3119201#M110551 HotChilli 2023-03-08T15:15:43Z