Calculate due date based on relationship

Question

Been struggling with this one. Hope you might help! 🙂

I have two tables: one holds historical data about employees trainings (tab_Historico) and the other one is my relational table (dTreinamentos), where I keep the training codes and its particularities (like Due Date in number of days, "[Validade_Dias]").

What I need to do is SUM the number of days to expiry from dTreinamentos[Validade_Dias] to tab_Historico[_DataConclusao], making sure I only get the latest correspondence to the [Concat_Historico] (id).

Tables:

The primary-key is "Concat_Historico" and "Concat".

tab_HistoricodTreinamentos

az38 · Answer

Hi&nbsp;Anonymous&nbsp;
as you have relationships why dont you try a very simple statement like
DueDate = [_DataConclusao] + [Validade_dias]
?&nbsp;

anonymous · Answer

az38,&nbsp;it doesn't work, since [Validade_Dias] is a calculated column from [Validade_Anos].&nbsp;Validade_Dias = [Validade_Anos] * 365&nbsp;

az38 · Answer

Anonymous&nbsp;
i don't see why it doesn work if it is a really column, not a measure
and what your desired output? give an example

anonymous · Answer

&nbsp;"A single value for the 'Validade_dias' column in the 'dTreinamentos' table cannot be determined. This can occur when an application formula refers to a column that contains multiple values ​​without specifying a minimum, maximum, count or sum to obtain a single result."&nbsp;az38&nbsp;, that's the message I get...My desire output would be the due date in datetime format. Like this:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

az38 · Answer

Anonymous&nbsp;
if you have many-to-many relationship what the second or evene third rules for finding appropriate Validate_dias if one COncat_Historico has more then one Validade_dias value?
maybe smth like
&nbsp;
&nbsp;
_Vencimento = tab_Historico[Data_Conclusao] * CALCULATE(FIRSTNONBLANK(dTreinamentos[Validade_Dias], 1), dTreinamentos[Concat] = tab_Historico[Concat_Historico], dTreinamentos[ID de Entidade] = tab_Historico[_User])
&nbsp;
&nbsp;

Forum Discussion

Calculate due date based on relationship

6 Replies

Related content

Relationship

Relationships

Relationship Issue

Calculate growth based on calculation group item

Creating relationships