How to Sum value in DAX

Anything related to PowerPivot and DAX Formuale
noorbaksh
Posts: 3
Joined: Tue Mar 27, 2018 5:57 pm

How to Sum value in DAX

Postby noorbaksh » Tue Mar 27, 2018 6:07 pm

How could I get required result in power pivot(CALCULATE FUNCTION)


RAW DATA COLUMNS

Date...............Qty............... Warehouses----Transactions--------Contractors
5-Mar-18----------10----------------- WH-1----------Transfer-------------- Habib
5-Mar-18-----------10-----------------WH-2--------- Transfer Received--- Asim
16-Mar-18---------100----------------WH-1--------- Transfer----------------Habib
16-Mar-18---------100-----------------WH-2----------Transfer received----Asim
19-Mar-18----------25---------------- WH-3---------- Transfer--------------- Noor
19-Mar-18----------25----------------- WH-4---------- Transfer received----Moor


Required Result
Contractosr WH-I+WH-2-----------WH-3+WH-4
Habib-----------------110
Asim------------------110
Noor-------------------------------------------25
Moor-------------------------------------------25

Total----------------220-----------------------50
Last edited by noorbaksh on Tue Mar 27, 2018 6:30 pm, edited 1 time in total.

noorbaksh
Posts: 3
Joined: Tue Mar 27, 2018 5:57 pm

Re: How to Sum value in DAX

Postby noorbaksh » Tue Mar 27, 2018 6:16 pm

how i could required result in power pivot(CALCULATE FUNDCTION)


RAW DATA COLUMNS

Date...............Qty............... Warehouses----Transactions--------Contractors
5-Mar-18----------10----------------- WH-1----------Transfer-------------- Habib
5-Mar-18-----------10-----------------WH-2--------- Transfer Received--- Asim
16-Mar-18---------100----------------WH-1--------- Transfer----------------Habib
16-Mar-18---------100-----------------WH-2----------Transfer received----Asim
19-Mar-18----------25---------------- WH-3---------- Transfer--------------- Noor
19-Mar-18----------25----------------- WH-4---------- Transfer received----Moor


Required Result
Contractosr WH-I+WH-2-----------WH-3+WH-4
Habib-----------------110
Asim------------------110
Noor-------------------------------------------25
Moor-------------------------------------------25

Total----------------220-----------------------50


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 14 guests