we are moving from static php reporting dashboard in the fire service where data is only presented in tables pulled from SQL server.
I have transformed this into a power bi dashboard with more interactions. so where as for example, the primary and secondary fires were 2 separate tables, now, its a filter.
The challenge now, is how to incorporate the Targets. Targets are held in an excel file by month and financial year FOR each of the tables - so for example primary fires has its own target, by month, by year.
The challenge now is how to structure this target spreadsheet, in a way that will work with my model. #general-power-bi
My initial thought is to manually create this as a measure for each one for each year (500 measures across 2 years)
Please see sample table structure attached. Any help will be greatly appreciated.
Sample tables.xlsx (11.4 KB)