Appending 2 tables - one with NULL and another with VALID values. Need to GROUP BY/ DE-DUPLICATE

[Anonymous]

Hello Gurus,

I am trying to append 2 tables into 1. Both tables have set of common dimension columns including one column for 'Period' as shwon below. The picture 1 below shows what I get when I append them and the second picture shows what I need. I need to basically ONLY consider the non-NULL values for the column "Total Sales - Dept1" for the Oct-2030 period coming from table 2 and discard the null ones com table 1. Other columns should get appended as is. Is "Append Queries" the right way to go for this or should I be using "Merge Queries". I think there is way to use GROUP by where I consider the MAX value for the 'Period' column but I am not sure how to use it OR if there is a better way. Any help would be greatly appreciated.

[DavisBI · Accepted solution]

Hi, @Anonymous ,

I've simplified your data sources as follows and using "merge queries" is the right way :

Then you just need to using "merge column" ,then remove the others column and duplicated rows:

Mark this post as solution if this helps, thanks!

[amitchandak]

@Anonymous , Append and aggregate  -https://radacad.com/power-bi-aggregation-step-1-create-the-aggregated-table