Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
Why not just a new column like:
IF([Previous Page] = [Page],BLANK(),[Views])
Why not just a new column like:
IF([Previous Page] = [Page],BLANK(),[Views])
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |