Forum Discussion

kunal_mehta1's avatar
kunal_mehta1
Helper I
3 years ago

DAX For Creating Column - Power BI

Hi All,
I am trying to create a calculated column in a calculated table, where i have the data as follows:
Project Number

O1234
O2345
O3456
I want to create a new column where i would have the same last 4 digits but starting with letter "C" in the same table.
For example,

Project Number     C Project Number

O1234                      C1234
O2345                      C2345
O3456                      C3456


Can someone please help me with this query.
Thanks.

"Need Help"

1 Reply

  • tackytechtom's avatar
    tackytechtom
    Most Valuable Professional
    3 years ago

    Hi kunal_mehta1 ,

     

    How about this:

     

     

    And here the code in DAX for a calculated column:

    CalcColumn = 
"C" & RIGHT ( 'Table'[Project Number], 4 )

     

    Probably DAX is not the right tool for this task since it appears you are trying to cleanse the data. Consider doing such things in Power Query instead if that suits your approach. I can help you with that as well if you like.

     

    Let me know 🙂

     

    /Tom
    https://www.tackytech.blog/
    https://www.instagram.com/tackytechtom/