kfschaefer1
New Member
- Joined
- Feb 28, 2016
- Messages
- 9
How do I convert the following, so I can use it within the query (DAX)?
=IFERROR(IF([@ResourceType]<>"Salaried/W-2","",LOOKUP(2,1/(([@Resouce]=SalaryDetail_Data!A:A)*([@Dates]=SalaryDetail_Data!C:C)),SalaryDetail_Data!D:D)/12),"")
thanks,
Karen
=IFERROR(IF([@ResourceType]<>"Salaried/W-2","",LOOKUP(2,1/(([@Resouce]=SalaryDetail_Data!A:A)*([@Dates]=SalaryDetail_Data!C:C)),SalaryDetail_Data!D:D)/12),"")
thanks,
Karen