cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mokrane_bob Frequent Visitor
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
Highlighted
Arul Member
Member

Re: Get two column with value from another column

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

1 REPLY 1
Highlighted
Arul Member
Member

Re: Get two column with value from another column

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

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 6 members 2,429 guests
Please welcome our newest community members: