locked
Power Pivot DAX formula RRS feed

  • Question

  • Hi All,

    request your help to know the dax formula for the below row data in power pivot calculated field.

    REGION AMOUNT

    EAST 1000
    WEST 2000
    NORTH 3500
    SOUTH 4000
    EAST 500
    NORTH 1000
    SOUTH 2000



    RESULT

    EAST +WEST----------------------- 3500
    EAST +WEST- NORTH------------ -1000
    SOUTH/EAST---------------------- 4
    (EAST*WEST)/NORTH----------- 667
    Sunday, February 17, 2019 2:36 AM