Forum Discussion
Solved
Create a table based on two tables
Hi Team I have two tables that I need to combine based on a year criteria. Table 1 shows the number or items sold during certain year, and the Table 2 is the database created after 2019 that co...
Hi,
This is my solution :
1- In Table 2 I create the Year column based on the date column in Power Query :
2- Append 2 tables and delete :
3- Create the below measure in new table :
# Article Sold = if(SELECTEDVALUE('Sheet220-1'[Number]) <> BLANK(),SELECTEDVALUE('Sheet220-1'[Number]),CALCULATE(COUNT('Sheet220-1'[Year])))Now could use the measure in Table visual or anywhere :Thanks for Kudos and please mark it as solution if it helps
Hi,
This is my solution :
1- In Table 2 I create the Year column based on the date column in Power Query :
2- Append 2 tables and delete :
3- Create the below measure in new table :
# Article Sold = if(SELECTEDVALUE('Sheet220-1'[Number]) <> BLANK(),
SELECTEDVALUE('Sheet220-1'[Number]),
CALCULATE(COUNT('Sheet220-1'[Year]))
)
Now could use the measure in Table visual or anywhere :
Thanks for Kudos and please mark it as solution if it helps