Forum Discussion
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 ...
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/