Forum Discussion
Multiple IDs to one fact table
Hello mattao44
Attached is the pbix, with small changes in the mapping table, and added measures to the fact table, and see the table : Hope this is what was intented. If you don't want to change the mapping table structure it can be achieved using different method. Please let me know if this helps.
I have attached a simplified PBIX file below. I have also included the intended output I am looking for. The only thing to note is that there could be muliple rows in the Fact table for the same client code, therefore the measures would need to aggregate.
https://drive.google.com/file/d/1rcMj8VxbSgG3yy9JVvQuFaGbroLs4OXr/view?usp=sharing
Hello mattao44
Attached is the pbix, with small changes in the mapping table, and added measures to the fact table, and see the table : Hope this is what was intented. If you don't want to change the mapping table structure it can be achieved using different method. Please let me know if this helps.