Forum Discussion
Restructuring Data with Lookup values - Help & Suggestions Needed
I currently have the following data set up from a query from Salesforce and I need the data restrured by year as every project has a three year projection but all projects combined do not maintain th...
Hello SLONG0718 ,
try to structure your data model as a star schema data model
https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
Thank you! this has been very helpful. Now I am struggling to combine the "Year 1", "Year 2" columns and ensuring that they populate in the correct corresponding year now that i have created a calendar table and created the relationship.
In the image below the "AHN Institute" should have the $16,800,000.00 value in 2020 and not be an additional column under 2019. Any suggestions?
