Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Month Selected + 3

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! 
 
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks.