Forum Discussion
How to eliminate data using DAX
I have data as below, is there any way to elimate the first two rows data and Keep only Unique values in the visual. please help. Thanks in advance
BhavyaM , Create this measure and use in visual level filter and check for non blank
if( max(Table[Date from]) = calculate(max(Table[Date From]), filter(allselected(Table), Table[Category Id] = max(Table[Category ID]))) , 1,balnk())
Using the above query it will elimate the Min date values. But what i want to show is for one category there will be multiple product and for each product there will be multiple date from and date to.
If any product is having different date from and date to or same date from and date to with below scenario
-13,700 +13,700 it will be = 0. So i want to remove this kind of data and keep only Unique values.