DAX Filter Out / Exclude Certain Values in summarize columns

[J_Mug]

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,

[v-yueyunzh-msft · Accepted solution]

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