Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

RE: SUMMARIZE AND SUM

Hi,   Good day.   I am making a report again and I do have a problem creating a 'pivot-table-look-a-like. Below is 2 tables i need to create using DAX. See the data and expected result.   TABLE...
DAX
Need Help - Goals
SUMMARIZECOLUMNS
Washivale's avatar
Washivale
Icon for Resolver V rankResolver V
6 years ago

Hi Anonymous ,

 

if you have first table as your raw table, you would just use Matrix visual, with below configurations.

 

Row Section - Doc Type, Department

Column Section - Current Status

Values- Sum of Original Amount

 

Other Option is to use Pivot Option from Power Query, by Selecting Current Status as Pivot column.

 

Hope this helps.

 

Regards,

-Washivale