How to add new column with existing value

[kalif]

please find below table, need to new column like "expect" column based by BKG_Num & Con_Cum (earlier month come at expect column)

BKG_NUM	CON_NUM	MONTH	EXPECT
SHALBND00579	AMFU3154791	October-18	October-18
SHALBND00579	AMFU3154791	November-18	October-18
SHLCGP000394	AMFU3154791	April-18	April-18
SHLCU18000007	AMFU3154791	April-18	April-18
SHLCU18000007	AMFU3154791	September-18	April-18
SHLCGP000463	AMFU3157928	June-18	June-18
SHLCGP000500	AMFU3198784	June-18	June-18
SHLCGP000500	AMFU3198784	July-18	June-18

[Minseven · Accepted solution]

add a calculated column:

EXPECT2 = 
CALCULATE (
    MIN ( Table1[MONTH] ),
    ALLEXCEPT ( Table1, Table1[BKG_NUM], Table1[CON_NUM] )
)

You will maybe have to rewrite your MONTH column to have month readable syntax

[kalif]

Thanks MinSeven