Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

SUM, SUMX or...?

Hi everyone

 

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.

 

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.

E.g: 30/09/2020 + 10 = 10/10/2020 

 

How can I do this calculation? I create a new column and ...should I use SUM or SUMX?

 

Thank you in advance 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Worked out! Thank uuu

View solution in original post

2 REPLIES 2
AntrikshSharma
Community Champion
Community Champion

@Anonymous  If you have to create a calculated column then just use Table[ColumnName] + 10

Anonymous
Not applicable

Worked out! Thank uuu

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors