Hello, I am working on creating calculated columns in a tabular analysis service. I am currently trying to calculate a Cumulative Sum across a Date field, a Name field, and a classification. For any given Date I would like to know the sum for a given Name
and it's classification. My current query looks like the code below. This gives the correct data, but is clunky in Power View. If I deselect the Classification choice in Power View I would like the Date and Name to then have a Sum of all of the classifications,
and if I further remove the Name I would like to have a grand total of the cumulative sum for each team on a given date. Does anyone know of a way to better find the cumulative sum that will allow for this, or is it a limitation of Power View?
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.