Forum Discussion

Live_Mace's avatar
Live_Mace
Frequent Visitor
2 years ago
Solved

SUMIFS Calculation with Dax

Dax novice here... I need help creating a measure: SPLIT_DROP_DEMAND... on excel this will be done with a SUMIFS: =F2/SUMIFS(F:F,D:D,D2,C:C,C2,A:A,A2)*G2   So the drop_demand is joined on a wa...
Need Help
Show and Tell
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    Hi,

    This calculated column formula works

    Split drop demnd = DIVIDE(Data[DEMAND],CALCULATE(SUM(Data[DEMAND]),FILTER(Data,Data[WAREHOUSE]=EARLIER(Data[WAREHOUSE])&&Data[SKU]=EARLIER(Data[SKU])&&Data[PERIOD_YEAR]=EARLIER(Data[PERIOD_YEAR]))))*Data[DROP_DEMAND]

    Hope this helps.

     

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

Hi,

This calculated column formula works

Split drop demnd = DIVIDE(Data[DEMAND],CALCULATE(SUM(Data[DEMAND]),FILTER(Data,Data[WAREHOUSE]=EARLIER(Data[WAREHOUSE])&&Data[SKU]=EARLIER(Data[SKU])&&Data[PERIOD_YEAR]=EARLIER(Data[PERIOD_YEAR]))))*Data[DROP_DEMAND]

Hope this helps.

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    2 years ago

    You are welcome.