How to eliminate value if two pages are similar

[snandy2011]

Hi, all,

I am in a simple problem but can not find the solution. I have data sets like,

Previous Page              Page              Views

abc                               bcd                15

cde                               abc                 25

efg                                bcd                30

abc                               abc                50

def                               cde                  10

I want to create a DAX  that, if previous page and page are same, then views will not be shown. otherwise it will show. That means, in above datasets, only one row will be eliminated, otherwise it will remain same.

I have tried to achieve by different formula, but could not achieve.

Can you guys help me for that?

Thanks,

snandy2011

Please help me to solve this problem.

[Greg_Deckler · Accepted solution]

Why not just a new column like:

IF([Previous Page] = [Page],BLANK(),[Views])

[snandy2011]

Sometimes, we forget to do some simple things. I tried your formula by DAX, but did not come into my mind that i could have created a column by same formula.Shame!!

Thanks a lot sir, for helping me.

Thanks,

snandy2011

[Greg_Deckler]

Happy to help!