Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Flag column for first instance

I need to create a column that returns a 0 or a 1 based on the first instance. Could someone help me?   Machine Work Order Material Batch Production Day Machine Scrap Good Qty xxxx xxx...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi  Anonymous ,

 

Here are the steps you can follow：

1. In Power Query -- Add Column – Index Column – From 1.

2. Create calculated column.

First Instance =
IF(
    [Index]=
MINX(
    FILTER(ALL('Table'),'Table'[Good Qty]=EARLIER('Table'[Good Qty])),[Index]),1,0)

3. Result:

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly