cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Get two column with value from another column

Hello,

 

It's simple what i want to do but i can't reach it.

I have this 

Capture.PNG

Now i want to have two columns which will be filled according to the colomn source.

If the type is Newsletter => this will be filled in the new column for Newsletter.
if the type is Enquête => this will be filled in the new column for Enquête

Capture2.PNG

Thank you

1 ACCEPTED SOLUTION

Accepted Solutions
Helper IV
Helper IV

Hi @mokrane_bob ,

You have to do this applied steps in your edit queries.

Screenshot (21).png

 

Go to edit queries and then,

1.Duplicate that column

2.Promote first row as headers

3.Replace value for column 1

4.Replace value for column 2

 

Regards,

-Arul

View solution in original post

1 REPLY 1
Helper IV
Helper IV

Hi @mokrane_bob ,

You have to do this applied steps in your edit queries.

Screenshot (21).png

 

Go to edit queries and then,

1.Duplicate that column

2.Promote first row as headers

3.Replace value for column 1

4.Replace value for column 2

 

Regards,

-Arul

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors