Daily Like for Like in a single table ?

[girard_ben]

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.

[swuehl · Accepted solution]

Maybe using a DateLink table?

[girard_ben]

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