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 everyone,
I'm trying to create a new column that will return the MAX value for an item in a particular Month & Year if the value is 0.
If the value is >0, it should return the same value.
In my case the value is the "Selling Price". Ideally, it should return the new column "Revised Selling Price for the Month".
Thank you all!
Solved! Go to Solution.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
It works wonderfully thanks a lot!!
@Anonymous , Try a new column like
measure =
var _1 = maxx(filter(Table, [Month] =earlier([Month]) && [year] = earlier([year])), [selling price])
return
if([selling price] =0, _1, [selling price])
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 |
---|---|
118 | |
107 | |
70 | |
70 | |
43 |
User | Count |
---|---|
148 | |
104 | |
104 | |
89 | |
66 |