Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to use DAX Filter function with date filter

i am trying to use DAX filter function to  to create a new column based on  this query, i keep getting a scalar error when i try to create the column. could someone  please give me some guidance on h...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi, Anonymous 

    Please add a measure filter like:

    Measure1 =
IF (
    MAX ( 'Table'[xyz] )
        IN { "ClOSED", "COMP", "CROWNER", "OPSDEFREV", "PEERREVIEW", "WAITINGRER" }
            && MAX ( 'Table'[orderedate] ) >= DATE ( 2022, 01, 01 ),
    1,
    0
)

    Then apply it to table visual filter pane to filter data rows.

    Best Regards,
    Community Support Team _ Eason

     

     

     

v-easonf-msft's avatar
v-easonf-msft
Community Support
4 years ago

Hi, Anonymous 

Please add a measure filter like:

Measure1 =
IF (
    MAX ( 'Table'[xyz] )
        IN { "ClOSED", "COMP", "CROWNER", "OPSDEFREV", "PEERREVIEW", "WAITINGRER" }
            && MAX ( 'Table'[orderedate] ) >= DATE ( 2022, 01, 01 ),
    1,
    0
)

Then apply it to table visual filter pane to filter data rows.

Best Regards,
Community Support Team _ Eason