Forum Discussion

KGOLSEN's avatar
KGOLSEN
Frequent Visitor
2 years ago

Create a duplicate a column as a measure using DAX?

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

Need Help

1 Reply

  • Daniel29195's avatar
    Daniel29195
    Icon for Community Champion rankCommunity Champion
    2 years ago

    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! 🤠