Forum Discussion
TamlerloversKant
May 18, 2022Copper 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.
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] )
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] )
- TamlerloversKantCopper ContributorThanks Sergei, thats ideal!
TamlerloversKant , glad to help
- Riny_van_EekelenPlatinum Contributor
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.
- TamlerloversKantCopper ContributorThanks Riny, Much appreciated. thats a great option.