Trying to create [estimated training days] column

[Anonymous]

I'm trying to either to create a calculated column or a DAX for a column called [estimated training days] which will be using values from two different columns. 

The first column will be the [entry start date] which contain the values of the start date in this format DD/MM/YYYY 
and the second column will be the [duration] which contain the values of the number of days that were allow for each course in a format of integer.

Right now I'm trying to add another column into my visualization to show to estimate date to complete the training by adding the values from [entry start date] and [duration] together. However, I don't think I could just simply add DD/MM/YYYY with an Integer. Please help me figure this out.

[Pragati11]

Hi @Anonymous ,

You can try creating a caluclated column as follows:

dateTimeMerged = Table1[entry start date] + Table1[duration]

Replace Table1 with your tablename.

Then change the above column's format to DATETIME under Modelling tab.

Thanks,

Pragati

Thanks,

Pragati

[Anonymous]

Hi @Pragati11 

When I try to look for [entry start date] it wasn't in the list. I am not sure if it has anything to do with the icon.

It has a calendar icon.

[Pragati11]

Hi @Anonymous ,

Every date column in Power BI becomes a hiererchy by default. It should not affect the calculation.

Click on the arrow you see a date hierarchy.

Did you try the dax I suggested?

Thanks,

Pragati

[Anonymous]

Hi @Pragati11 
I have tried your DAX and it does not work because I can only use the measure and I don't know why. when I type the name of my table the only thing that i could see were my measures not the other column

[Pragati11]

Hi @Anonymous ,

Are you creating a caluclated column or measure?

Create calculated column. It will show you table columns.

Thanks,

Pragati

[Anonymous]

I see. I was trying to create a measure that's why it doesn't show.

It works now when I try to create the calculated column. However, I ran into another problem

dateTimeMerged = Table1[entry start date] + Table1[duration]
entry start date and duration is in a different tables. Is there a way to make it works?

[Pragati11 · Accepted solution]

Hi @Anonymous ,

Are these 2 tables related to eachother by some common column?

If yes then modify calculation as follows:

dateTimeMerged = Table1[entry start date] + RELATED(Table2[duration])

If tables are not related then create relationship between them.

Thanks,

Pragati