Forum Discussion
Modelling XML IATI data in PowerBI - multiple categories, apportioned expenditure
Hi everyone, I'm hoping to get some advice on a data model I am attempting to build using International Aid Transparency Data. The IATI standard is an XML formatted, nested structure. What I'm tryi...
Anonymous , You should merge the last three tables into third one to get % columns, sector, and country.
Using those % you should create a new column with the actual value for country sector combination
amitchandak
Super User
Super UserAnonymous , You should merge the last three tables into third one to get % columns, sector, and country.
Using those % you should create a new column with the actual value for country sector combination