Problem with DAX Time Intelligence Functions

[ed_crowson]

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

[chass]

Hello Ed, You still having this issues? Closing while waiting for a reply Thanks chuck

[chass]

Hey Ed, Not certain i understand the problem. Chass@microsoft.com Can you send me the xlsx file? Thanks, Chuck

[chass]

Been having issues with my email and would like to verify if you have/haven't sent me the xlsx file Thanks Chuck