Formula to copy same cell

[dreyes6]

Hello, 

Just need to know if there is a possibility to create a DAX to mirror the data from one cell to another.

Original Data

ID	NAME	ING
10	A	IT
10	A
10	A
10	A
1	B	PET
2	C	FINS
13	DEF
13	DEF
13	DEF	Retail
29	LC
29	LC
29	LC	Manufacturing
59	ONE	CARE
122	GOAT	GOAT
123	DYE	Food and Beverage
1234	BRI	BRI
88	Science
88	Science
88	Science	PROP
26	BOD	BOD
74	MIM
22	Mort
22	Mort	Service

Output Should be like this

ID	NAME	ING
10	A	IT
10	A	IT
10	A	IT
10	A	IT
1	B	PET
2	C	FINS
13	DEF	Retail
13	DEF	Retail
13	DEF	Retail
29	LC	Manufacturing
29	LC	Manufacturing
29	LC	Manufacturing
59	ONE	CARE
122	GOAT	GOAT
123	DYE	Food and Beverage
1234	BRI	BRI
88	Science	PROP
88	Science	PROP
88	Science	PROP
26	BOD	BOD
74	MIM	LIVE
22	Mort	Service
22	Mort	Service

We are looking for the column ING.

Thanks

[Jos_Woolley · Accepted solution]

Hi,

You mean as a new Calculated Column?

=
VAR ThisID = Table1[ID]
RETURN
    CALCULATE(
        MIN( Table1[ING] ),
        FILTER(
            Table1,
            Table1[ID] = ThisID
        )
    )

Regards

[dreyes6 · Accepted solution]

Hi Jos,

yes a new calculated column, and it looks like your DAX works, Thank you much!!!

[Jos_Woolley · Accepted solution]

Hi,

You mean as a new Calculated Column?

=
VAR ThisID = Table1[ID]
RETURN
    CALCULATE(
        MIN( Table1[ING] ),
        FILTER(
            Table1,
            Table1[ID] = ThisID
        )
    )

Regards

[dreyes6 · Accepted solution]

Hi Jos,

yes a new calculated column, and it looks like your DAX works, Thank you much!!!

[Jos_Woolley · Accepted solution]

You're welcome!

Regards