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.
l have a table which contains 2 columns: number and order. l need a column "next_number" . l want to have the value of next row of the column number sort by order. when the next number is null, we take the next number not null.
Number | order | Next_number |
1,32 | 1 | 2,3 |
2,3 | 2 | 0.9 |
0,9 | 3 | 0,5 |
0 | 4 | 0,5 |
0 | 5 | 0,5 |
0,5 | 6 | 69 |
69 | 7 |
Please l need help.
Solved! Go to Solution.
Hi,
Thank you for your feedback, and sorry that I missed your requirement.
Could you please check if the below and the attached pibx file are providing a correct result?
Next number CC =
VAR nextorder =
MINX (
FILTER ( Data, Data[order] > EARLIER ( Data[order] ) && Data[Number] <> 0 ),
Data[order]
)
RETURN
MAXX ( FILTER ( Data, Data[order] = nextorder ), Data[Number] )
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 gives the value of next row. but when the next value of number is "0" it is supposed to skip it bcause it is null and use the next value of number not null.
Hi,
Thank you for your feedback, and sorry that I missed your requirement.
Could you please check if the below and the attached pibx file are providing a correct result?
Next number CC =
VAR nextorder =
MINX (
FILTER ( Data, Data[order] > EARLIER ( Data[order] ) && Data[Number] <> 0 ),
Data[order]
)
RETURN
MAXX ( FILTER ( Data, Data[order] = nextorder ), Data[Number] )
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.
Hi,
Please check the below picture and the attached pbix file.
It is for creating a new column.
Next number CC =
VAR nextorder =
MINX ( FILTER ( Data, Data[order] > EARLIER ( Data[order] ) ), Data[order] )
RETURN
MAXX ( FILTER ( Data, Data[order] = nextorder ), Data[Number] )
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.
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |