The Date Challenge!

[Anonymous]

Hi Experts!

I've a simple table with ID, OrderDate and Sales.

I also have another table which is not linked with the above table. This table has a list of dates like a calendar.

I want to be able to select any date from Calendar and then show all the OrderDate which >= Calendar Date and <= CalendarDate+15days.

For example if I select date 01/04/2016 I get this list:

Now what I actually want is a straight table that looks like this:

Is this something possible?

[karthiksrqv]

Hi Waqas,

Add the above expression as your calcuated dimension.

[tresesco]

A code may come in different dates, and how would you want to deal such situation, show against only one date? if so which date?

[sunny_talwar]

I guess the OP wants, that once a Code is available on a day, it should be made available on every subsequent day after it was first available in that 15 day window

[Anonymous]

That;s exactly what I'm looking for Sunny!

[tresesco]

You may create the data accordingly in the script using Peek()/Previous(). Check it here :How to populate a sparsely populated field