Forum Discussion

Mkrishna's avatar
Mkrishna
Icon for Helper III rankHelper III
2 years ago
Solved

Removing existing date filter before applying new date filter---DAX

Hi,  I am working on a project. The objective of the project is  1. To find the number of store visited in last 3 months. For example. If the user select March -2024, then it will be unique store v...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Mkrishna ,

    Please update the formula of variable STORE as below:

    VAR STORE =
CALCULATE (
    COUNTROWS (
        FILTER (
            ALL ( 'TRAX SOS' ),
            'TRAX SOS'[store_number] = MAX ( 'Canvas'[Store Number] )
                && 'TRAX SOS'[Visit Date] = MaxDate
                && 'TRAX SOS'[Visit Date] >= DATE ( 2023, 12, 01 )
                && 'TRAX SOS'[Visit Date] <= DATE ( 2024, 02, 29 )
                && 'TRAX SOS'[Brand] IN ALLSELECTED ( 'Product'[Brand] )
        )
    ),
    USERELATIONSHIP ( 'TRAX SOS'[Visit Date], 'Date'[Date] )
)

    Best Regards