DAX For Creating Column - Power BI

kunal_mehta1 — Tue, 04 Apr 2023 04:01:09 GMT

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.

Re: DAX For Creating Column - Power BI

tackytechtom — Tue, 04 Apr 2023 04:47:46 GMT

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/

topic Re: DAX For Creating Column - Power BI in DAX Commands and Tips

DAX For Creating Column - Power BI

Re: DAX For Creating Column - Power BI