Hi, Thanks in advance.
I couldn't find a way of uploading a file to the forum. The link below is a google drive link to a copy of the file.
In a previous post:-
I was kindly supplied with a measure to do the first calculation I need.
I need an additional column which deals diffrently with negatives in the measure column. Therefore the 'New Measure' column instead of -negative numbers uses a 0 and only uses positive numbers in the calculation. See illustration below.
I hope this makes sense.
Solved! Go to Solution.
Thanks @lbendlin . Not sure what list.Accumaulate is, will have a look. I'm not sure it matters if the result is a column so long as it does the calcultion and can be filtered by a slicer.
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.