Missing Date using month filter

manju421 — Sat, 16 Nov 2024 17:43:21 GMT

If I select month Nov, I should be able to see Deal 1 & 2, as they are active in month of Nov because there end date is Dec.

Now I can only see Deal 3&4

Re: Missing Date using month filter

Taoufiq_Zarra — Thu, 10 Dec 2020 08:34:41 GMT

@manju421 can you confirm , if you select Nov you should be able to see Deal 1 & 2 &3 &4 also ?

for exemple you can use this script to :

Data: load Deal,Date#([Start Date],'D-MMM-YY') as [Start Date],Date#([End Date],'D-MMM-YY') as [End Date] inline [ Deal,Start Date,End Date 1,2-Oct-19,20-Dec-19 2,6-Oct-19,21-Dec-19 3,11-Nov-19,22-Dec-19 4,18-Nov-19,23-Dec-19 5,2-Dec-19,24-Dec-19 ]; left join load Deal,Month(Date([Start Date] + IterNo() - 1)) as MonthFiltre resident Data While [Start Date] + IterNo() -1 <= [End Date];

output:

topic Re: Missing Date using month filter in App Development

Missing Date using month filter

Re: Missing Date using month filter