Add minutes in DateTime Power BI

[Kyointruder]

How to add minutes from column TB_PRAZO_CHAMADO[NR_prazo] + VW_CHAMADO_SUPORTE[DT_Hora_Registro] and store in a new column?
as I'm doing a query via direct query I can't import the data or use the addition of a column via DAX in Power query.
it would have to be even in the Power BI visual itself. I've tried the code above but it doesn't work. the tables have a
relationship with the ID_prazo column.

[liuqi_pbi · Accepted solution]

Hi @Kyointruder 

Calculated columns are limited to being intra-row, as in, they can only refer to values of other columns of the same table, without the use of any aggregate functions (Reference doc). So I think it is not possible to use RELATED function to get the minutes values from another table to create a new column in the first table. 

You can try creating a measure to add two values with your original DAX Code. 

Cheers

If this reply helps solve this problem, please mark it as Solution! Kudos are appreciated too!

[Kyointruder]

In fact I can rather access the values by "Related" the problem is that in VW_Chamado_Suporte has blank values i.e. they have no deadline. this is the current problem.

[amitchandak]

@Kyointruder , In Direct query you can use related , if the date table in on many side

you can try a column like

TB_PRAZO_CHAMADO[NR_prazo] + related(VW_CHAMADO_SUPORTE[DT_Hora_Registro])

refer, if needed https://www.youtube.com/watch?v=aA4ROG9dg8A

[Kyointruder]

Tried this. no work too:

[Kyointruder]

Thanks for the feedback. But I tried to do the recommended, but the result did not come as expected

Actual relationship: