Get Value from one Column to Another When One Column Starts With A Character: Prefer DAX

[tksnota]

Hi,

Can anyon help me on this one so the respected columns will only be populated by the appropriate values.

Thanks...tksnota...

[v-rzhou-msft · Accepted solution]

Hi @tksnota ,

I think you can try code as below to create calculated columns. If [reknr] is data like 40010, you can set the data format as whole number.

reknr_crd (DAX) = IF('Table'[reknr] = 40010 || 'Table'[reknr] in GENERATESERIES(70000,79999,1),'Table'[bdr_hfl],0)

reknr_drd (DAX) = IF('Table'[reknr] in GENERATESERIES(80000,89999,1),'Table'[bdr_hfl],0)

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[suparnababu8]

Hi @tksnota 

Can you pls provide a sampl data with editable form not int the image. So, we'll help you to solve your problem.

Thanks

[ryan_mayu]

could you pls provide the sample data (not the screenshot) and the expected output?