Forum Discussion
Solved
transpose? or combining data labels
Hi, I am connecting to the ONS open source API in Power BI using the information below: Source = Json.Document(Web.Contents("insert api link here because it won't let me post")), #"Converted...
Did a messy fix by adding an index field after #"Expanded observations1" and then duplicating the tables after all the steps, filtered on wd in one table and disability in the other and then joined via the index... it's not perfect but it works 😀
Did a messy fix by adding an index field after #"Expanded observations1" and then duplicating the tables after all the steps, filtered on wd in one table and disability in the other and then joined via the index... it's not perfect but it works 😀