adding new customers to fact table

[Minakshi]

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

[Greg_Deckler]

@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.

[amitchandak]

@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

[Minakshi]

@amitchandak 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?