Forum Discussion
Field twice in table view
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
6 Replies
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
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
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
