Forum Discussion
Solved
Formula to copy same cell
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 ...
Hi,
You mean as a new Calculated Column?
= VAR ThisID = Table1[ID] RETURN CALCULATE( MIN( Table1[ING] ), FILTER( Table1, Table1[ID] = ThisID ) )Regards
Hi Jos,
yes a new calculated column, and it looks like your DAX works, Thank you much!!!
You're welcome!
Regards
Hi,
You mean as a new Calculated Column?
=
VAR ThisID = Table1[ID]
RETURN
CALCULATE(
MIN( Table1[ING] ),
FILTER(
Table1,
Table1[ID] = ThisID
)
)Regards
Hi Jos,
yes a new calculated column, and it looks like your DAX works, Thank you much!!!
You're welcome!
Regards