Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

If function + left and right

Hi all,  I have the below table and trying to make an end of month formula, but I don't the formula calculates wrong.  EOM = EOMONTH(IF(AND('Finance Forecast - Test'[FYPeriod]>7, 'Finance Fo...
Help with DAX
if
if statement
  • Anonymous's avatar
    Anonymous
    5 years ago

    That is the answer of my question for anyone interested in 

    EOM = EOMONTH(IF('Finance Forecast - Test'[FYPeriod]<=6, DATE(LEFT('Finance Forecast - Test'[FY],4), 'Finance Forecast - Test'[FYPeriod]+6, 1), DATE(2000+RIGHT('Finance Forecast - Test'[FY],2), 'Finance Forecast - Test'[FYPeriod]-6, 1)),0)
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Try like

EOM =
var _col = if([FYPeriod] >=6 , [FYPeriod] -6, [FYPeriod] +6)
return
eomonth(date(left([FY],4),_col,1),0)

Anonymous's avatar
Anonymous
Not applicable
5 years ago

amitchandak I don't know why my reply wasn't shown up here

the formula is incorrect again 

i cannot calculate years