Forum Discussion
extract single value
Hi, in the attached sheet, C4 extracts the unique values from C3 with conditions C1-A && C2-P1in C4 - 500, If C2 is duplicated single value should consider in C4. Hence the reuired Column is...
It returns the following table in Power Query:
It does it by inserting an Index column first, then getting the previous row by referencing the index value - 1.
Thanks, the result is rigth, ist possible to share the Pbix file to understnad better.
Hi Anonymous ,
Or you could do like this:
First, create a [Index] column in "Edit Queries";
Second, create a calculated column:
Column = VAR x = MOD([Index], 2) RETURN IF( x = 0, BLANK(), [C3] )Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
It need not in a sequence .. the records in C3 will not be in sequence. In that how to resolve this?
- My post had a link to a file Chandra.
Could you please share the file
