Results 1 to 1 of 1

Thread: Calculated Columns - Total Amortized and Total Unamortized

  1. #1
    Acolyte ExcelQuestion's Avatar
    Join Date
    May 2018
    Excel Version
    Office 365

    Calculated Columns - Total Amortized and Total Unamortized

    Register for a FREE account, and/
    or Log in to avoid these ads!

    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)

    Click image for larger version. 

Name:	CalculatedColumns.PNG 
Views:	23 
Size:	11.9 KB 
ID:	8567

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

    Thanks in advance,
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts