DAX For Creating Column - Power BI

[kunal_mehta1]

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.

[tackytechtom]

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/