Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
sumpekung
Frequent Visitor

Create new column from another column with conditions

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.

 

sumpekung_1-1674541993898.png

 

Also welcome for another idea to solve the problem. 

 

 

1 ACCEPTED SOLUTION
olgad
Super User
Super User

Hi @sumpekung ,

i do it in Power Query

olgad_0-1674545524358.pngolgad_1-1674545549013.pngolgad_2-1674545593022.png

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


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime

View solution in original post

3 REPLIES 3
Iloris
New Member

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

olgad
Super User
Super User

Hi @sumpekung ,

i do it in Power Query

olgad_0-1674545524358.pngolgad_1-1674545549013.pngolgad_2-1674545593022.png

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


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors