Need some help with dax to transform a table

[kalkito]

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

[v-shex-msft]

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