December 4, 2015 at 8:54 am
I'm hoping somebody can help me!
I am using Tabular SSAS, and have two datasets.
Loans - This lists out all loans that have been sold.
Interest - This shows how much interest is made on the loan per month, along with the date the interest is charged each month (named InterestDate). So one row from Loans is duplicated many times in this dataset, depending on how many months the loan has to run.
This is what I am trying to achieve. I need to create a measure in the Loans dataset that would sum up all the interest for each loan. This way, when I am just interrogating the Loans dataset via a pivot, no rows are duplicated and I see the sum of interest per line.
I also then want to split this sum of interest if I decide to drag in the InterestDate field into the Columns section in the pivot table.
I hope this makes sense! Any help is really appreciated!!
December 7, 2015 at 3:32 am
Anyone? 🙂
December 7, 2015 at 8:16 pm
you will need to SUM the relevant column - this then exposes the result as a measure. Select the column and the click on the sigma sign in the tool bar.
You can also to MTD, YTD measures if you wish. Sites such as http://www.powerpivotpro.com/ have a stack of info on this (Time Intelligence is what you want to look for)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply