Hello triveni,

show from today date to  last 15 days sales and quantity manually.

What did you mean by "manually"?

Your requirement can be simply solved by Quick Start: Relative Date Filters

But if you mean not using filter by "manually", you can the calculation such as,

SUM(IIF(DATEDIFF('day',[Order Date],TODAY())<=15 AND [Order Date]<=TODAY(),[Sales],0))

Regards.

Hello TRIVENI,

Could you please attach a sample workbook?

It's necessary to have a look at the relationship of your datasources and the view you're creating before actually creating the calculated field.

Regards.

Hi Triveni,

Please share the relationship that you have established for the blending. I would also like to know if the date field is in the both the tables. It would be great if you can share the workbook.

Thanks and Regards,

Ashish Chaudhari

Hello TRIVENI,

I have two questions.

1) what's logic between Sales(Purchase Date) and Inventory (Date)?

In your requiements, "last 15 days sales" is required but Sales(Purchase Date) should not be used.

I'm a little confused, so could you explain the logic between the two dates?

2) how do you deal with sku field?

Datasource inventory has 598 unique sku's

Datasource sales has 743 sku's

They are N-to-N, but sku is defined as linked field.

Regards