Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

IF function based on date

Hi all, Have a DAX calculation I need to create, was hoping I could get some help with it. I have the below table for a recruiter. It looks at employees, the date they're leaving the company, and th...
wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
3 years ago

NewColumn=VAR _n=Table[FullName] RETURN IF(Table[Y_Fee_Calc]=0||COUNTROWS(FILTER(TOPN(8,FILTER(Table,Table[Y_Fee_Calc]>0),Table[Leavedate],ASC,Table[Y_Fee_Calc],DESC),Table[FullName]=_n)=0,"NOCAP","CAP")

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thank you so much for the quick reply! The calculation is definitely on the right track, but I seem to be getting an error when I enter it - COUNTROWS has too many filters, the maximum is 1. Is there any  way around this?

 

Thanks again! 

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Community Champion
    3 years ago

    please show your real code