Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
I have a table campaign in which in have campaign dates
in another table Order I have Order dates
campaign and order table are linked in datamodel
when I select campaign date it should select 30 days date from that selected campaign date in order table
for eg
if i select 01/01/2016 in campaign table
so in order table it should select the date from 01/01/2016 to 30/01/2016
thanks in advance
Please check this.
Script:
Complain:
LOAD [Complain Date],
[Order Number],
Amount
FROM
(ooxml, embedded labels, table is Sheet1);
Order:
LOAD [Order Date],
[Order Number],
Qty
FROM
(ooxml, embedded labels, table is Sheet5);
Output:
I think, this is answer your question. If I select Complain Date as "01-02-2012", then table will show data for Complain Date from 01-02-2012 till last 30 Days.
Try like this
//assuming your trying to count the Orders
count({<[Order dates]={">=max([campaign date])-30<=max([campaign date])>}Order)
Try this,
=Sum({<[Order dates]={">=$(=date(max([campaign date])-30))<=$(=date(max([campaign date])))>}OrderValue)