Forum Discussion

Anonymous

Not applicable

6 years ago

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...

Community Champion

6 years ago

Check out the file attached.

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.

Anonymous

Not applicable

6 years ago

Thanks, the result is rigth, ist possible to share the Pbix file to understnad better.

v-lionel-msft
Community Support
6 years ago
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 Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Anonymous
  Not applicable
  6 years ago
  It need not in a sequence .. the records in C3 will not be in sequence. In that how to resolve this?
  - v-lionel-msft
    Community Support
    6 years ago
    Hi Anonymous ,
    
    The [Index] column is not added for sorting, but to lock the rows in each group (grouped by C1 and C2 columns), because the values of C3 after grouping of C1 and C2 columns are the same, so the condition cannot be judged.This is a convenient calculation method.
    
    Best regards,
    Lionel Chen
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
edhans
Community Champion
6 years ago
My post had a link to a file Chandra.

Related content