topic Re: Create new column from another column with conditions in DAX Commands and Tips

Create new column from another column with conditions

sumpekung — Tue, 24 Jan 2023 06:33:49 GMT

Hi,

I'm trying to compare the defect quantity from same lot when it was run at different operation. The problem is the lot didn't pass through each operation in the same day, so I can't use date column to be shared X-axis in column chart. My idea is to create new column "Newdate", value in this column will bring from date column but use only date of operation 2.

Also welcome for another idea to solve the problem.

Re: Create new column from another column with conditions

olgad — Tue, 24 Jan 2023 07:34:02 GMT

Hi sumpekung ,

i do it in Power Query

Please kudo and accept the solution if you use it, hopefully it works.

Re: Create new column from another column with conditions

sumpekung — Tue, 24 Jan 2023 08:59:03 GMT

Thanks a lot, I will try to apply with my actual report.

Re: Create new column from another column with conditions

Anonymous — Fri, 03 Feb 2023 12:15:46 GMT

It works. I tried to use it on similar task. Thank you.