Home Forums Data Warehousing Analysis Services Tabular help! - 1 to Many relationships/Measures based on other tables RE: Tabular help! - 1 to Many relationships/Measures based on other tables

  • 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)