Copy Calender Table to Another Table

[Anonymous]

Hi,

I have calender Table which i need to copy the dates to Another table(Unique Value).

Calender Table:

TxnDt

17-Mar

18-Mar

19-Mar

20-Mar

21-Mar

22-Mar

23-Mar

Table 2:

StoreName	Store Num
Mayflower Basildon SF	11
Crownhill Plymouth SF	112
Leigh SF	113

Expected Result:

StoreName	Store Num	TxnDt
Mayflower Basildon SF	11	17-Mar
Mayflower Basildon SF	11	18-Mar
Mayflower Basildon SF	11	19-Mar
Mayflower Basildon SF	11	20-Mar
Mayflower Basildon SF	11	21-Mar
Mayflower Basildon SF	11	22-Mar
Mayflower Basildon SF	11	23-Mar
Crownhill Plymouth SF	112	17-Mar
Crownhill Plymouth SF	112	18-Mar
Crownhill Plymouth SF	112	19-Mar
Crownhill Plymouth SF	112	20-Mar
Crownhill Plymouth SF	112	21-Mar
Crownhill Plymouth SF	112	22-Mar
Crownhill Plymouth SF	112	23-Mar

[Greg_Deckler]

@Anonymous You can use GENERATE or GENERATEALL like:

New Table = GENERATEALL('Table 2', 'Table 1')

[Anonymous]

Thank you this helps. 

I need to copy the % from another table to current table(Newly created one), can you help me to it.

I have used this DAX but didn't helped.

Store Name-SH =
VAR _Domain =
CALCULATE(
FIRSTNONBLANK('04_StoreConsoDaily'[NewAdoption],1),
FILTER(ALL('04_StoreConsoDaily'),'04_StoreConsoDaily'[TxnDt]='CHeck'[TxnDt])
)
RETURN
IF(_Domain = BLANK(),0,_Domain)

 Table 1:

StoreName	Store Num	TxnDt	Percentage
Mayflower Basildon SF	11	17-Mar	10%
Mayflower Basildon SF	11	18-Mar	10%
Mayflower Basildon SF	11	19-Mar	10%
Mayflower Basildon SF	11	20-Mar	10%
Mayflower Basildon SF	11	21-Mar	10%
Mayflower Basildon SF	11	22-Mar	10%
Mayflower Basildon SF	11	23-Mar	10%
Crownhill Plymouth SF	112	17-Mar	20%
Crownhill Plymouth SF	112	18-Mar	20%
Crownhill Plymouth SF	112	19-Mar	20%
Crownhill Plymouth SF	112	20-Mar	20%
Crownhill Plymouth SF	112	21-Mar	30%
Leigh SF	113	17-Mar	20%
Leigh SF	113	18-Mar	20%
Leigh SF	113	19-Mar	30%
Leigh SF	113	20-Mar	40%

Table 2: 

StoreName	Store Num	TxnDt
Mayflower Basildon SF	11	17-Mar
Mayflower Basildon SF	11	18-Mar
Mayflower Basildon SF	11	19-Mar
Mayflower Basildon SF	11	20-Mar
Mayflower Basildon SF	11	21-Mar
Mayflower Basildon SF	11	22-Mar
Mayflower Basildon SF	11	23-Mar
Crownhill Plymouth SF	112	17-Mar
Crownhill Plymouth SF	112	18-Mar
Crownhill Plymouth SF	112	19-Mar
Crownhill Plymouth SF	112	20-Mar
Crownhill Plymouth SF	112	21-Mar
Crownhill Plymouth SF	112	22-Mar
Crownhill Plymouth SF	112	23-Mar

Expected Result:

StoreName	Store Num	TxnDt	Percentage
Mayflower Basildon SF	11	17-Mar	10%
Mayflower Basildon SF	11	18-Mar	10%
Mayflower Basildon SF	11	19-Mar	10%
Mayflower Basildon SF	11	20-Mar	10%
Mayflower Basildon SF	11	21-Mar	10%
Mayflower Basildon SF	11	22-Mar	0%
Mayflower Basildon SF	11	23-Mar	0%
Crownhill Plymouth SF	112	17-Mar	20%
Crownhill Plymouth SF	112	18-Mar	20%
Crownhill Plymouth SF	112	19-Mar	20%
Crownhill Plymouth SF	112	20-Mar	20%
Crownhill Plymouth SF	112	21-Mar	0%
Crownhill Plymouth SF	112	22-Mar	0%
Crownhill Plymouth SF	112	23-Mar	0%

[Anonymous · Accepted solution]

Closing this query as not response received for 2nd query. Appreciate my 1st query resolved.