I have a great repo case in an Excel file. Trying to understand the issue without that file is nearly impossible; with the file it is easy. The problem is with the following measures: 1) KeyCount:=CALCULATE(COUNT([Key])) 2) KeyCount PrevMnth:=CALCULATE([KeyCount], PREVIOUSMONTH('Date'[Date])) 3) KeyCount FYTD PrevMnth:=TOTALYTD([KeyCount], PREVIOUSMONTH('Date'[Date]),"8/31") 4) KeyCount FYTD PrevMnthx:=TOTALYTD([KeyCount PrevMnth], 'Date'[Date],"8/31")
4 Comments
- Hello Ed, You still having this issues? Closing while waiting for a reply Thanks chuck
- Hey Ed, Not certain i understand the problem. [email protected] Can you send me the xlsx file? Thanks, Chuck
- Been having issues with my email and would like to verify if you have/haven't sent me the xlsx file Thanks Chuck
- Status added:Abandoned
