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.