Forum Discussion
Copy Calender Table to Another Table
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 |
3 Replies
Anonymous You can use GENERATE or GENERATEALL like:
New Table = GENERATEALL('Table 2', 'Table 1')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%
