Forum Discussion
Prior FYTD - Having Issues
I'm currently working on an all too common report where I want to show the dollars spent Fiscal YTD against Prior FYTD down to the day. I'm using the below DAX formula to successfully calculate FYTD...
parry2k
Super User
Super UserAnonymous in your base measure Amount FYTD you are adding full FY data, since there is no future dated data, it looks like you are summing upto date but Sameperiodlastyear is giving you full last fical year.
Either you look at paralledperiod function or filter your base measure to current date and PY FYTD will work
parry2k could you see my above reply?