Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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...
Need Help
Show and Tell
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    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.

  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    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)] )
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Sadly, I am getting the following error message:

 

Too few arguments were passed to the DATE function. The minimum argument count for the function is 3.

 

I have changed the / to , but that doesn't work.  If I change the month from 8 to 08 - it returns the same error.  Any thoughts?

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

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)] )
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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