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 | |
| 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
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
3 Replies
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