Forum Discussion

kincaids's avatar
kincaids
Helper II
9 years ago

Seemingly simple date issue...

My company rents band & orchestra instruments to school children.  I have a handful of data query tables and I've created a calendar table.   For this issue, I think all I need to focus on are thes...
Need Help
kincaids's avatar
kincaids
Helper II
7 years ago

d_gosbell,

 

I hate to do this again, but still a syntax error...

 

 

d_gosbell's avatar
d_gosbell
Super User
7 years ago

yep, just a missing comma after the ALL() function. 

 

Current Rentals =
VAR _maxDate =
    MAX ( 'Calendar'[Date] )
RETURN
    CALCULATE (
        COUNTROWS ( 'scrental' ),
        FILTER (
            ALL ( 'scrental'[Contract Date], 'scrental'[Return Date] ),
            'scrental'[Contract Date] >= _maxDate
                && (
                    'scrental'[Return Date] = BLANK ()
                        || 'scrental'[Return Date] <= _maxDate
                )
        ),
        'scrental'[Dunn] IN { "P", "N" }
    )