Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Sumproduct formula in PowerBI

Hi All,    I have an excel formula I need to translate in DAX, anyone know how to do it?   =SUMPRODUCT(ISNUMBER(MATCH(EmployeeRange,A1,0))*ISNUMBER(MATCH(EmploymentRange,{"Full-Time","Part-Time"}...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    With this calculated column formula, here is the result i get

    Column = if(CALCULATE(COUNTROWS(Data),FILTER(Data,Data[EmployeeID]=EARLIER(Data[EmployeeID])&&(Data[EmployeeRole]="Full-time"||Data[EmployeeRole]="Part-time")))>=1,1,BLANK())

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Ashish_Mathur  This works like an absolute charm. Thanks so very much for your time on this, its greatly appreciated. Its exactly what I need, a 1 or a 0 aganst each employee ID. 

 

Really genius! 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

You are welcome.  Thank you for your kind words.