Create a duplicate a column as a measure using DAX?

[KGOLSEN]

My issue is somewhat unique (and eternally frustrating).

I need to preface that in my current role that I am unable to alter models. Meaning I can't make new calculated columns or create relationships. This makes things very frustrating when trying to perform seemingly simple tasks.

My current issue that I am attempting to tackle is to simply duplicate a column, but as a Measure so that I can perform a Lookup function. I know that it is simple to do this with a calculated column, but I am working with pretty limited control.

Please help 😕

Thank you

[Daniel29195]

@KGOLSEN 

i didnt totally understand your requirement, 

however , in a measure, you can use addcolumns function, and add columns to a temp table created in the measure. 

this way, in this temp table, you can duplicate columns as much as you need. 

hope this helps .

if not, please share a presentation of what you want to achieve .

best regards ,

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠