Reply
New Member
Posts: 1
Registered: Thursday

Need some help with dax to transform a table

[ Edited ]

Hi, new at PBI

 

I need help to tranform some attributes the folowing way:

 

In each line first airport can be an origin and/or a destination, depending on if there is >0 in take off (then it´s an origin) or a destination if landings is more or equal then one. The same with passengers.

 

Attributes: Date / Aiport A / Airport B / number of Landings / number of Take-off / Pax landed / Pax take-off

 

Observation example1: 01-01-2018 / Lisbon / London / 2 / 3 / 50 / 20 >>>>Lisbon is a destination, London an origin, pax landed 50 (two movements totalling 50 pax) + Lisbon is a ORIGIN, London an DESTINATION, pax took off =20 (three movements totalling 20 pax) 

This means I need to convert one line in two lines with these rules.

 

Observation example2: 01-02-2018 / Lisbon / London / 2 / 0 / 50 / 0 >>>>> Lisbon is a destination, London an origin, pax landed 50 (two movements totaling 50 pax)

This means no convertion here.        

 

Any advice?

 

Many thanks in advance.

 

Paulo

 

 

Community Support Team
Posts: 6,927
Registered: ‎08-14-2016

Re: Need some help with dax to transform a table

Hi @kalkito,

 

Can you please share some sample data with expected result to help us clarify your requirement and test to coding formula?

How to Get Your Question Answered Quickly

 

Notice:

1. you can upload same data to onedrive or google drive then share link here.
2. do mask on sensitive data before sharing.

 

Regards,

Xiaoxin Sheng