Hi,
I need to create a new column based on the length of a number within another column if possible.
The column I have is numeric (job_no). I need the new column to say:
if Job_no starts with a 6, then 'NEW' else 'OLD'
Any idea how to write the DAX for this please?
I need to create a new column based on the length of a number within another column if possible.
The column I have is numeric (job_no). I need the new column to say:
if Job_no starts with a 6, then 'NEW' else 'OLD'
Any idea how to write the DAX for this please?