didijaba
Well-known Member
- Joined
- Nov 26, 2006
- Messages
- 511
HI,
I'm working in Excel 2016, 64bit, and I'm creating measures for products sold during time in portfolios. My measure is simple
Problem is that when I place this measure under Values in Pivot table of Excel 2016, I can not create running total over time or projects? Any ideas how to fix this?
I'm working in Excel 2016, 64bit, and I'm creating measures for products sold during time in portfolios. My measure is simple
Code:
=CALCULATE(SUM(tblOfferSaleData[SoldPrice]),
FILTER('tblOfferSaleData',
LASTDATE('Calendar'[Date])>=MAX(tblOfferSaleData[SoldDate],tblOfferSaleData[SoldOccupiedDate]) &&
FIRSTDATE('Calendar'[Date])<=MAX(tblOfferSaleData[SoldDate],tblOfferSaleData[SoldOccupiedDate]) &&
tblOfferSaleData[SoldPrice]>0))
Problem is that when I place this measure under Values in Pivot table of Excel 2016, I can not create running total over time or projects? Any ideas how to fix this?