Sum of Values from this date and 2 dates back

[lukacvetko]

Hello everyone,

In a picture below, there is a problem I'm facing. I believe the solution can't be that hard, but iz seems that I'm missing it.

Simple Sales data (sales and calendar table in data model).

Straight table that contains "Date" dimension and  expression "sum of Quantity on that Date + Previous 2 Dates".

WantedValue in picture is something that I want, but can't figure out how.

Additional Note: Calculation should be aware that there could be data before 1.7.2016 and has to take it into account.

Thank you.

Regards,

Luka

[lukacvetko]

Hi. Close, but it still doesn't solve 2 problems that I mentioned in a reply to Sravanthi Aluvala.

[MK_QSL · Accepted solution]

I have reduced data from your application and added few codes in script as well.

Let me know whether this will help you or not.

Regards,

MK

[lukacvetko]

Manish,

Thank you very much. I believe this is a right solution.

Just one additional question, why *avg(1) ?

Regards,

Luka

[MK_QSL]

It's a dummy field which will not make any changes.. but without that if you select any month, year or any calendar field, it will not ignore those lines..

Just remove Avg(1) from my expression and select any monthyear and see the effect. You will understand.

[lukacvetko]

Understood. Thanks again.