Forum Discussion

gmasta1129's avatar
gmasta1129
Resolver I
2 years ago
Solved

SumProduct formula with Power BI

Hello,

 

I have a formula (see below) in excel that needs to be converted for Power BI.  

 

How would I write this formula in Power BI?

 

=IF(A2="","",IF(SUMPRODUCT(($D$2:$D2=D2)*($C$2:$C2=C2))>1,0,1))

 

Column D = CUST_NO

Column C = CUSTOMER

Column A = CUST_CLASSIFICATION

 

 

 

Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    2 years ago

    CalculatedColumn=IF(ISBLANK(Table[CUST_CLASSIFICATION]),BLANK(),IF(COUNTROWS(FILTER(Table,Table[CUST_NO]=EARLIER(Table[CUST_NO])&&Table[CUSTOMER]=EARLIER(Table[CUSTOMER]))),1,0))

1 Reply

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Community Champion
    2 years ago

    CalculatedColumn=IF(ISBLANK(Table[CUST_CLASSIFICATION]),BLANK(),IF(COUNTROWS(FILTER(Table,Table[CUST_NO]=EARLIER(Table[CUST_NO])&&Table[CUSTOMER]=EARLIER(Table[CUSTOMER]))),1,0))