I am doing a POC where I am trying to track historical values using snowflake pattern. Scenario is something like below
I'll have a customer who buys something thru an Account Manager. Customer can switch between Account Managers. What I am interested to see is, to have the customer name, all revenue from that customer thru all current/past acccount managers and the name of the current manager (it could repeat across all rows).
Attached the sample pbix file. (link below). I am trying to follow a pattern that is mentioned in this book "Agile Data Warehouse Design" by Lawrence Corr. I was not sure if the pattern mentioned in the book was achievable so thought of checking it myself and it seems like I am stuck in implementing this properly
@karun_r , Yet to check the file. But As in power Bi we prefer star schema, I would merge the Account manager name from the employee table by joining account manager ID with employee ID (Column name may differ)