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 ...
Closing this query as not response received for 2nd query. Appreciate my 1st query resolved.
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% |
Closing this query as not response received for 2nd query. Appreciate my 1st query resolved.