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...
Anonymous 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
Could you give me an example of what those functions would like like with parallel period etc... or using today's date?