Would you please advise, how would you denormalise such a data model as this one?
Client journey and Mapping table can be brought into CM Data as it already contains it. Zip code can be linked to store location, just can't seem to link store location to my fact table which is CM Data.
In my mind i will make 5 tables to 3 tables, please advise?
Thank you in advance.
Helpful resources
The Power BI Community Show
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
Join us for Microsoft Power Platform Conference
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
