Field twice in table view

[Anonymous]

Hello all, I have the below table view which I have created and I would like to add the rc-number field twice but only showing certain data

 

The first rc-number I would like to show is based upon the rc-type in the same DB with type vehicle and the 2nd is rc-number with type labour. There can only be 1 vehicle per line but there could be multiple labour. 

Is this even possible and if so how could I do this? I have tried varying things like importing the table twice and filtering the 2nd table on labour only but that doesn't work. I have tried a calcultated table but that did work. As soon as I add in rc-number from the 2nd table it cannot create a link. I'm a bit of a noob so I'm sure I am doing this the long way round.

thanks 

[v-jiascu-msft]

Hi @Anonymous,

What's the expected result? Can you share it please? Maybe you can add a column like this, then add it in the report.

New Col =
IF (
    [rc-number] = "GF61 CWZ"
        && [re-type] = "Vehicle",
    1,
    IF ( [rc-number] = "GF61 CWZ" && [re-type] = "Labour", 2, 0 )
)

Best Regards,

Dale

[Anonymous]

Hi @v-jiascu-msft, i suppose the expected result is something like this. I have added an extra column. I want it to show multiple people who are assigned to the action.

I tried adding that column but got this

[v-jiascu-msft]

Hi @Anonymous,

Can you share your pbix file? Or a dummy sample. Maybe you can add RELATED to the two columns.

New Col =
IF (
    [rc-number] = "GF61 CWZ"
        && RELATED ( [re-type] ) = "Vehicle",
    1,
    IF ( [rc-number] = "GF61 CWZ" && RELATED ( [re-type] ) = "Labour", 2, 0 )
)

Best Regards,

Dale

[Anonymous]

Hi @v-jiascu-msft, I'm afraid that had an error to. the pbix file is here.

https://www.dropbox.com/s/v191x5d8u9frqno/Truck%20Diary.pbix?dl=0

thanks 

[v-jiascu-msft]

Hi @Anonymous,

I'm afraid it's almost impossible to do it directly. Because there is no such data existed. For example, the "GF61 CWZ" only has type "Vehicle". BTW, is this what you want?

rc-number   re-type  other columns

GF61 CWZ   Vehicle                             (only one row)

GF61 CWZ   Labour

GF61 CWZ   Labour

Please be aware of your privacy, the download link is available to the whole Internet.

Best Regards,

Dale

[Anonymous]

Hi @v-jiascu-msft, I have remoed the file and thanks for the heads up.  I suppose I don;t mind how the data looks. If I could create a new table with just the data from the vehicles or labour in it then great. as long as I can make the view look like the example I have given. there is always 1 vehicle per DDiD but there can me multiple labour.

thanks