Have you tried setting up 'Compute Using' on the field after you drag it to filter?
It seems to be working on the workbook attached, but I'm not sure if that is the result you are looking for.
Hope this helps!
Data Extract_v10.5.twbx 49.6 KB
Thank you for your help - I am one step closer, but would now like to display only those dates which have a value.
Describing this range indicates both positive and negative values, so I can't use a > 0 filter to solve this problem.
Have also tried filtering by DAY(Date): 1 but this would mess up the Compute Using: Table (across then down) table calc.
Would you have any other approaches ?
No worries. I'm not sure I totally understand. Could you share a few examples?