Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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])
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |