CODEWITHSUNDEEP
powerbidax
Zornjac
Zornjac

Reputation: 261

DAX Between a date range syntax

I would like to run my SUMX() with a FILTER() between a date range that I want hard coded. What I have doesn't work when I add in the between date range component. See code below:

EnquiryTest = 
SUMX (
    FILTER ( '_enquiries,' '_enquiries'[_tsg_clientid_value] = 'accounts[accountid']) &&
    '_enquiries'[Date] => {08/01/2018} && 
    '_enquiries'[Date] =< {08/01/2018},
    _enquiries[Amount (Enq)]
)

What is the proper syntax for a between date range?

Upvotes: 0

Views: 90

Answers (1)

Alexis Olson
Alexis Olson

Reputation: 40264

Instead of {08/01/2018}, try DATE(2018,08,01).

Upvotes: 1

Related Questions