Forum Discussion

J_Mug's avatar
J_Mug
Helper I
3 years ago
Solved

DAX Filter Out / Exclude Certain Values in summarize columns

Hi,

 

I am not able to solve this by myself, 

 

I have a table with values (+10000) that is generated via summarize colums with different values, I want to dynamically exclude the values that are in another table and that have been added in the last six months,

 

I tried to use this as a filter in the summarize columns function, which counts correctly and shows the records I want to eliminate:

 

FILTER('Data',Calculate(COUNT('Data'[Data]),DATESBETWEEN(Calendar[Date],EOMONTH(TODAY(),-6), TODAY())))
 
Is there any way to do the opposite of this is in Dax? What I want is for the result of the summarize columns not to include the records in 'Data' table that has been registered in the last 6 months.
 
Thanks,
 
 
Need Help
Tips and Tricks

1 Reply

  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    Community Support
    3 years ago

    Hi, J_Mug 

    For logical judgments in DAX, if you want to get the opposite result, you can try using the NOT() function:

    NOT function (DAX) - DAX | Microsoft Learn

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly