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")
... View more