Missing Date using month filter

[manju421]

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 

 

[Taoufiq_Zarra · Accepted solution]

@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: