Forum Discussion
DAX for between a date range Q
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 = SU...
It should be:
EnquiryTest = SUMX ( FILTER ( '_enquiries,' '_enquiries'[_tsg_clientid_value] = 'accounts[accountid']) && '_enquiries'[Date] => DATE(2018/8/1) && '_enquiries'[Date] =< DATE(2018/8/31), _enquiries[Amount (Enq)] )
But, would need sample data to be sure.
Shoot, sorry about that, I meant to use commas:
EnquiryTest = SUMX ( FILTER ( '_enquiries,' '_enquiries'[_tsg_clientid_value] = 'accounts[accountid']) && '_enquiries'[Date] => DATE(2018,8,1) && '_enquiries'[Date] =< DATE(2018,8,31), _enquiries[Amount (Enq)] )
EnqAmt =
SUMX (
FILTER ( _enquiries, _enquiries[_tsg_clientid_value] = accounts[accountid] && _enquiries[Date] >= DATE(2018,08,01) && _enquiries[Date] <= DATE(2018,08,31) ), _enquiries[Amount (Enq)]
)#this_works
Shoot, sorry about that, I meant to use commas:
EnquiryTest = SUMX ( FILTER ( '_enquiries,' '_enquiries'[_tsg_clientid_value] = 'accounts[accountid']) && '_enquiries'[Date] => DATE(2018,8,1) && '_enquiries'[Date] =< DATE(2018,8,31), _enquiries[Amount (Enq)] )
Thank you for all of the help, Greg. I am still getting errors, but I have ordered some books to read over the weekend.
Respectfully,
J Morningstar
EnqAmt =
SUMX (
FILTER ( _enquiries, _enquiries[_tsg_clientid_value] = accounts[accountid] && _enquiries[Date] >= DATE(2018,08,01) && _enquiries[Date] <= DATE(2018,08,31) ), _enquiries[Amount (Enq)]
)#this_works