Set Analysis Syntax When Extra Function is Included

[dukane24]

I was wondering if somebody could give me some advice on what I'm doing wrong here.  This works fine until I include the piece where I'm trying to count items where the Est. Completion Date is 'less than' today.  I've tried multiple variations (less than in place of equals, with and without $, etc.)  and it seemed to work at one point but it was showing results where the Est. Completion Data was not being factored in at all.  As-is below, my chart is just saying "No data to display".  I have my date fields set in date format (M/D/YYYY) in the the load script.

count({$<[Current Status]-={'Completed','Withdrawn'},[Est. Completion Date]={$'<'(=Today(1))}>}[Defect ID])

I appreciate any advice you may have.  Thanks!

[jerem1234]

Try this:

count({$<[Current Status]-={'Completed','Withdrawn'},[Est. Completion Date]={"<$(=Today())"}>}[Defect ID])

or

count({$<[Current Status]-={'Completed','Withdrawn'},[Est. Completion Date]={"<$(=Date(Today(),'M/D/YYYY'))"}>}[Defect ID])

Hope this helps!

[Anonymous]

Try this:

count({$<[Current Status]-={'Completed','Withdrawn'},[Est. Completion Date]={"$(='<' & today())"}>}[Defect ID])

[MayilVahanan · Accepted solution]

Hi

Try like this

count({$<[Current Status]-={'Completed','Withdrawn'},[Est. Completion Date]={"<$(=Date(Today(1),'M/D/YYYY'))"}>}[Defect ID])

Hope it helps.

Note:

Please make sure both dates are in same format.

[dukane24]

Thank you!