Forum Discussion
Creating a table that is a pivot over another table
lottieritchie Hi will it be possible for you to share your powerbi sample file or more detailed information about your base data and output data. this will help us to provide you a solution. Thanks
Hi negi007 thanks for your reply.
I've got some personal data in my full data set so I've pulled out just the relevant table as a hopefully clearer explanation of what I am trying to achieve.
You'll see there is a table called 'Scope'. At the moment I have, for example, if you look at the column 'Property', and for example look at 15 The Park, you will see that 3 of the 5 rooms have the status 'Express Turn Around' in the column 'Turn Around'.
What I would like to get to is a table with each Property only listed once, and if any of the rooms for that property say 'Express Turn Around' then the Turn Around status for the whole property line item would be Turn Around.
I've created this in Excel to show my desired outcome / how I would have done this in excel!
Thanks for your help
negi007 Sorry just trying to work out how to upload a file on here, I can't see that I can?