Forum Discussion

kekepania0529's avatar
kekepania0529
Helper I
4 years ago
Solved

Excel SUMIFS conversion help

I have the following excel formula that I need to convert to DAX for Power BI (Power BI column names are in italics within the excel formula):   Area Contract Price = IFERROR(SUMIFS('Contract Detai...
Need Help
  • kekepania0529's avatar
    kekepania0529
    4 years ago

    i was able to get my desired results with this :

    Area Contract Pricing = AVERAGEX(FILTER( 'Contract Detail','Contract Detail'[Area] = 'Inbound Detail'[Area] &&
              'Contract Detail'[Product Class Desc] = 'Inbound Detail'[Material Grade]), 
              DIVIDE('Contract Detail'[Sell Extended Price], 'Contract Detail'[Sell Ordered LB], 0))
smpa01's avatar
smpa01
Community Champion
4 years ago

kekepania0529 not familiar with SUMIF. Can you provide sample data and expected output.