Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
Solved! Go to Solution.
Closing this query as not response received for 2nd query. Appreciate my 1st query resolved.
@Krishna_Newuser 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.
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |