Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I have a straight table with a like for like Analysis!! This works well but I need to select one day to achieve the computation.
> this is great for a daily report !
But now I need to create a monthly daily analysis where all days must be displayed...
Date Like for Like | Date | Quantity Previous Year | Quantity |
---|---|---|---|
03/01/2015 | 02/01/2016 | ||
04/01/2015 | 03/01/2016 | ||
.... |
but I my set analysis is not working well!!! => I have extra rows...
that I want
In my model I have a dedicated field in the "Master Calendar" to find the N-1 Date , it's Date_LFL.
The formula for the "Quantity LY" Measure
=SUM( {<Date={'$(=Date(max(Date_LFL),'DD/MM/YYYY'))'},Year=,Month=,Day>}Quantity*LFL_TY)
thanks in advance for you help.
Maybe using a DateLink table?
Maybe using a DateLink table?
Hi Swuehl,
you've right... I was just looking for this type of Calendar Table...
I'll add it very quickly 😉
Thanks a lot four you quick reply