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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
game1
Helper II
Helper II

Subtract the 3 dates from different tables

Hello,

I have Table2[dateBefore], Table1[dateBegin] and Table1[dateEnd].

So, I need to subtract the 3 dates, so I can have the result in DAYS:  so something like Table2[dateBefore] - Table1[dateEnd] - Table1[dateBegin] 

So, I create a new coloumn call DatesDiff = DATEDIFF(Table2[dateBefore], Table1[dateBegin], DAY) + DATEDIFF(Table2[dateBefore], Table1[dateEnd], DAY)

But the new coloumn call DatesDiff is create in Table1, so I can have acces to Table2[dateBefore].

How can I do if I want to subtract column from differents tables?  I need to have an ID common to the 2 tables to do that?

Can I do that using join?

Please, give complete answer.

1 REPLY 1
wdx223_Daniel
Super User
Super User

if all the IDs in those tables are unique, you can try to add a new step in table1

NewStep=Table.AddColumn(Table1,"DateDiff",each let a=Table2{[ID=[ID]]}?[dateBefore]? in a=null then null else Duration.Days(a-[dateEnd]-[dateBegin]))

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors