Month Selected + 3

[Anonymous]

Hi all, 

Can anyone please let me know why can't I get my F_Date = month selected + 3 ? 

am I missing something here?

CALC_MONTH_Increase =

var F_Date = Calculate(SELECTEDVALUE(t_Missions[Date Début Effective].[MonthNo])+3)

Var S_Date = Calculate(SELECTEDVALUE(t_Missions[Date Fin Effective].[MonthNo]))

var(SELECTEDVAL T_Type = CalculateUE(t_Missions[Type Mission]))

Return

IF(T_Type="Courant";
Calculate(DATEDIFF(S_Date;F_Date;DAY)))

Thank you so much! 

[Anonymous · Accepted solution]

Hi @Anonymous 

I think it depends on your data type. If you have to use ...[MonthNo] or not.

In my test I don't need to add .[MonthNo] because my month column is data typ "Whole number".

Best regards

Timo

[Anonymous]

Thanks.