May 26, 2014 at 8:08 am
Hi,
Analysis Services newbie here.
I have a Tabular Data Model which is being exposed via Excel and Power View.
The data is financial data, looking something like this table.
Type SubType Value
Expenditure Electricity478
Expenditure Salary 123
Expenditure Tax 789
Income Sales 896
Income Royalties 112
Profit is a derived value not a row in the source database or in the Tabular model. Profit is Income minus Expenditure.
I have used calculated columns and measures to summarize data and calculations for the Profit value and all are mathematically correct when using filters and slicers etc . But I cannot expose the Profit value as shown in the table below. I want the user to be able to choose a field using Pivot Table or Power View and they can see not just Income and Expenditure but also Profit. Is there a way of achieving this?
I'm happy to modify the model.
Type Value
Expenditure 478
Income 896
Profit 418
Apologies if this is blindingly obvious but I've hit a brick wall.
Thanks,
Dave
May 30, 2014 at 4:24 am
Okay, I have modified the data structure in the data warehouse. there was no obvious solution in the model.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply