topic SUM, SUMX or...? in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SUM-SUMX-or/m-p/1404513#M25892 <P>Hi everyone</P><P>&nbsp;</P><P>My question is simple but I really can´t understand the logic. I have a column with dates and I simply want to sum the number 10 in all of them in Power BI but it does not allow me.</P><P>&nbsp;</P><P>It is to measure Lead time, so lets say, a product has left the Warehouse and takes around 10 days to arrive at its destination.</P><P>E.g: 30/09/2020 + 10 = 10/10/2020&nbsp;</P><P>&nbsp;</P><P>How can I do this calculation? I create a new column and ...should I use SUM or SUMX?</P><P>&nbsp;</P><P>Thank you in advance&nbsp;</P> Wed, 30 Sep 2020 10:49:55 GMT Anonymous 2020-09-30T10:49:55Z SUM, SUMX or...? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SUM-SUMX-or/m-p/1404513#M25892 <P>Hi everyone</P><P>&nbsp;</P><P>My question is simple but I really can´t understand the logic. I have a column with dates and I simply want to sum the number 10 in all of them in Power BI but it does not allow me.</P><P>&nbsp;</P><P>It is to measure Lead time, so lets say, a product has left the Warehouse and takes around 10 days to arrive at its destination.</P><P>E.g: 30/09/2020 + 10 = 10/10/2020&nbsp;</P><P>&nbsp;</P><P>How can I do this calculation? I create a new column and ...should I use SUM or SUMX?</P><P>&nbsp;</P><P>Thank you in advance&nbsp;</P> Wed, 30 Sep 2020 10:49:55 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SUM-SUMX-or/m-p/1404513#M25892 Anonymous 2020-09-30T10:49:55Z Re: SUM, SUMX or...? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SUM-SUMX-or/m-p/1404605#M25894 <P>Anonymous</LI-USER>&nbsp; If you have to create a calculated column then just use Table[ColumnName] + 10</P> Wed, 30 Sep 2020 11:30:39 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SUM-SUMX-or/m-p/1404605#M25894 AntrikshSharma 2020-09-30T11:30:39Z Re: SUM, SUMX or...? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SUM-SUMX-or/m-p/1404931#M25905 <P>Worked out! Thank uuu</P> Wed, 30 Sep 2020 13:51:52 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/SUM-SUMX-or/m-p/1404931#M25905 Anonymous 2020-09-30T13:51:52Z