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
azaterol
Helper V
Helper V

Seperate in columns

Hello everyone,

 

I have the following table:
ID 1 is input price
and ID 2 is ouputprice.

I want to get two price columns.

If it is an ID 1 line, the prescribed price should be in the line under the entry price, otherwise $0.

The same with ID 2.

 

initial situation

ID Date Price
1 01/01/2020 $5
2 01/05/2020 $10
1 01/10/2020 $4
1 01/20/2020 $6
2 01/21/2020 $5

 

excepted situation

ID Date

 

Input price

 

output price

1 01/01/2020

 

$5

 

$0

2 01/05/2020

 

$0

 

$10

1 01/10/2020

 

$4

 

$0

1 01/20/2020

 

$6

 

$0

2 01/21/2020

 

$0

 

$5

 

Do you have an idea how I can solve this in Power Query?

1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@azaterol 

You can add two conditional columns as follows

Fowmy_0-1661175964908.png

 

Fowmy_1-1661175981624.png

 

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

2 REPLIES 2
Fowmy
Super User
Super User

@azaterol 

You can add two conditional columns as follows

Fowmy_0-1661175964908.png

 

Fowmy_1-1661175981624.png

 

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

@Fowmy  thank you. So simple and works great.

 

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.