Calculated Columns - Total Amortized and Total Unamortized

ExcelQuestion

New member
Joined
May 27, 2018
Messages
26
Reaction score
0
Points
0
Excel Version(s)
Office 365
Hello Experts,
How do you add a DAX Total Amortized column (years 2016 to 2018, in this example)? Then, add another DAX column Total Unamortized (Purchase Price - Total Amortized)?

I've started with a data input table. Then, used Power Query to unpivot the years, deleted the total columns...hoping that I would rely on PowerPivot to produce the totals calculations instead...for a more robust expandable schedule in the future.

Whatever total I came up with, it has always been paired next to each Year. How do you get just the 2 Total columns to show only at the end? I would like to keep the amount amortized by year (Year field dropped into the Column PivotTable field list)

CalculatedColumns.PNG

I've attached my example. Could you please help me? It'll be greatly appreciated.

Thanks in advance,
Ricky
 

Attachments

  • Excel - PowerPivot Calculate.xlsx
    185.4 KB · Views: 11
Back
Top