Forum Discussion
Resolver Iadding new customers to fact table
Hello everyone,
I have a fact table which looks like as below have customer visiting shops in August
| shop id | shop name | customer | day |
| 1 | AB | Ram | Monday |
| 2 | ABC | Raj | Tuesday |
| 3 | CDF | Rahul | Monday |
| 4 | GHI | Reena | Tuesday |
It shows which customer will visit the shop on which day. There is no date information in this table.
In september (next month), I got 2 more customers and they are also visiting on Monday and tuesday to shops.
| 5 | RF | Aman | Monday |
| 6 | TX | Anum | Tuesday |
when I try to get total number of customer, I got sum of both months while I want to keep it seprate for 2 months.
Can any one help me how can I combine these table so that new customers wont affect the count of previous month.
Thanks in advance
5 Replies
- amitchandak
Super User
Minakshi , first of in both tables add a month and then append them
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Minakshiamitchandak I want August month entries to be repeated in September as well. In this case realtionship with this with actual visit table will be many to many.
Will it be right?
- Greg_Deckler
Community Champion
Minakshi - Where is the month column?
- Minakshi
Greg_Deckler there is no month column till date in that table. It is just that I know which data belong to which month, ideally table works on days basis.
- Greg_Deckler
Minakshi - Human knowledge of data is nothing that you can put into a formula.
