Forum Discussion

nisuomi's avatar
nisuomi
Resolver I
9 years ago
Solved

DAX problem with date filtering

Hi,   I am having a little bit a problem when trying to figure out how to filter with DAX on my problem at hand. We are currently having some unit models which each have a own release date written...
Need Help
Tutorial Requests
  • nisuomi's avatar
    nisuomi
    9 years ago

    Hmm... Might have the solution already to my problem:

     

    SalesRange =
    CALCULATE (
    sum([hit]);
    FILTER (
    VALUES ( DataTable[date] );
    COUNTROWS (
    FILTER (
    UnitsTable;
    DataTable[date] >= UnitsTable[release date]
    )
    ) > 0
    )
    )

nisuomi's avatar
nisuomi
Resolver I
9 years ago

Hmm... Might have the solution already to my problem:

 

SalesRange =
CALCULATE (
sum([hit]);
FILTER (
VALUES ( DataTable[date] );
COUNTROWS (
FILTER (
UnitsTable;
DataTable[date] >= UnitsTable[release date]
)
) > 0
)
)

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi nisuomi,

 

Thanks for your sharing. If you have worked out your requirement, please kindly mark the corresponding post as an answer so that some others having similar problem can find the solution easily. 

 

Thanks,

Yuliana Gu