Forum Discussion
Filter with negative values
Hi There, I have a days overdue measure which has values 973 and -3900 I only want to see values that are larger than or equal to -90. In the filter panel when I use the filter...
My days ovedue are calculated as follows:
Days Overdue = (DATEDIFF([AA Last Performance date],TODAY(),DAY)).
If you have created a calculated column "Days Overdue" then this should work as desired unless you have some slicer or filters restricting the data.
Try to create a new table and put Days Overdue in that table and try restricting data there to see if it is returning blank or some values.