Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
LIVE
SOLVED

# PowerPivot Table - Total Column as a Multiplication of Values

Copper Contributor

# PowerPivot Table - Total Column as a Multiplication of Values

Good afternoon,

I am trying to create an additional total column in power Pivot Table as per the yellow highlighted column in my Snip Below:

The Total Rate is the "Rate" column, multipled by the "Total Hrs";

The Data for Rate for certain Roles is coming from a Lookup table which is linked to a data table containing all of the relevant hours worked by specific roles on specific Dates.

any assistance would be greatly appreciated, thankyou.

5 Replies

# Re: PowerPivot Table - Total Column as a Multiplication of Values

@TamlerloversKant Not sure that I have the perfect answer for you, but with a few DAX measures you can somewhat achieve what you want, though you get some extra columns.

See attached.

best response confirmed by TamlerloversKant (Copper Contributor)
Solution

# Re: PowerPivot Table - Total Column as a Multiplication of Values

As variant you may add row with Rates moving Values into Rows section

Not to show in each column measure could be

``Rate total::=IF( HASONEVALUE( Table1[Date]Table1[Date]), BLANK(), [Rate] )``

# Re: PowerPivot Table - Total Column as a Multiplication of Values

Thanks Riny, Much appreciated. thats a great option.

# Re: PowerPivot Table - Total Column as a Multiplication of Values

Thanks Sergei, thats ideal!

# Re: PowerPivot Table - Total Column as a Multiplication of Values

1 best response

Accepted Solutions
best response confirmed by TamlerloversKant (Copper Contributor)
Solution

# Re: PowerPivot Table - Total Column as a Multiplication of Values

As variant you may add row with Rates moving Values into Rows section

Not to show in each column measure could be

``Rate total::=IF( HASONEVALUE( Table1[Date]Table1[Date]), BLANK(), [Rate] )``