Forum Discussion

Helpful_Fun4848's avatar
Helpful_Fun4848
Helper III
5 years ago
Solved

Dax with dates filter not working

Hi all, I'm trying to create a measure to calculate between 2 dates and for specific companies but the following is not working. Any help would be much appreciated!   CALCULATE( SUM('vbi_POStatus...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    Helpful_Fun4848 Oh, duh:

    SUMX(FILTER(ALL('vbi_POStatus 2019-2021'),[PODate] > DATE(2018,12,31) && [PODate] < DATE(2020,1,1) && ([Supplier] = "ABC Supply West")),
[AmtOrdered]
)
Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

Helpful_Fun4848 Oh, duh:

SUMX(FILTER(ALL('vbi_POStatus 2019-2021'),[PODate] > DATE(2018,12,31) && [PODate] < DATE(2020,1,1) && ([Supplier] = "ABC Supply West")),
[AmtOrdered]
)