Forum Discussion
Time intelligence Past year sales
Hi, I am trying to calculate last year sales using a 454 fiscal calendar. The normal time intelligence functions like dateadd, same period last year don't seem to work. The fiscal week on my calendar...
Anonymous @Hi, no LY Net Demand is calculated using a measure not a calculated column
Hi ANE2 ,
If you are basing your LY Net Demand on my previous reply, then it gets the sum of the same week as last year, so it doesn't change based on each day in the line graph.
Also, if you want it to vary with the number of days, then consider the dates relative to last year, not the number of weeks, because as mentioned before, the same number of weeks does not correspond to the same number of days, which contradicts the display you are looking for.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.