Forum Discussion

gmasta1129's avatar
gmasta1129
Icon for Resolver I rankResolver 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))...
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))

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity 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))