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.
Hello,
I'm looking to create a range out of the values of Lower Limit Column
The data is laid out in two columns as shown in Current Data and the Expected outcome is below it.
Current Data:
Expected Outcome :
Thank you,
Hi,
You should ideally be creating this as a calculated column formula in the Table (not as a measure). Are you OK with my approach?
I tried this as Calculated column, range is not accurate. Check out my screenshot
If you are OK with my approach of creating a calculated column formula rather than a measure, then share the download link of the PBI file.
Range (calculated) =
var nextValue = CALCULATE(MIN('Table'[Range]), FILTER(ALL('Table'), 'Table'[Range] > EARLIER('Table'[Range])))
return IF(nextValue > 0,
'Table'[Range] & " - " & nextValue,
"> " & 'Table'[Range]
)
You can try something like the above
Thank you for your reply.
It does create a range but not accurate, here is my output.
Looks like the variable needs to be tied to the bucket column, so the range is locked to the adjacent bucket value.
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
146 | |
110 | |
107 | |
86 | |
63 |