Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Problems with DAX Date filter

Hi   I'm quite new to DAX and am experimenting with filters in CALCULATE, using a simple table of sales data containing data from 2017 to 2019 - here's an extract   Source data is at https:...
  • HotChilli's avatar
    HotChilli
    7 years ago

    Hi again,

    the bracket is in the wrong place in the measure. Should be

    YEAR(Sales[OrderDate]) = 2019)
HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
7 years ago

Hi again,

the bracket is in the wrong place in the measure. Should be

YEAR(Sales[OrderDate]) = 2019)
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks!

     

    What a difference a misplaced bracket makes! I should have spotted this myself.