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

Anonymous I am not good in Query, can you help me, please?