extract single value

Question

Hi,in the attached sheet, C4 extracts the unique values from C3 with conditions&nbsp;C1-A &amp;&amp; C2-P1in C4 - 500, If C2 is duplicated single value should consider in C4.&nbsp;Hence the reuired Column is C4 based on C1 &amp; C2&nbsp;&nbsp;&nbsp;https://drive.google.com/file/d/1l0bGaAX4p8uLjUXupxa2LZRpnvcvQj5R/view?usp=sharing&nbsp;&nbsp;

edhans · Answer

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.

edhans · Answer

Anonymous&nbsp;can you be more specific? You keep saying for us to share the file, but my first post has the file link.&nbsp;
&nbsp;
THen you keep responding that something isn't working. Can you please tell us EXACTLY what isn't working and what your expected output is? Help us help you. Just saying "it doesn't work" isn't helpful. Our solutions&nbsp;do work if implemented correctly&nbsp;and if&nbsp;we understand your requirements. You have to be very clear about what those requirements are, and what exactly isn't working to give those requirements
&nbsp;

anonymous · Answer

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

v-lionel-msft · Answer

Hi Anonymous ,&nbsp;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]
)&nbsp;Best regards,Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.&nbsp;

edhans · Answer

My post had a link to a file Chandra.

Forum Discussion

extract single value

10 Replies

Related content

Extract Value

Single-Value Slicer

Extract Data from sharepoint

Extract values from Json

Parameter single Value