Duplicate in Fact table

Power Query
1

Hi there,

I have a data model which looks like as follow:

image
image907×566 14.4 KB

Two tables are connected through EpochHH column. EpochHH is the unique number to represent the half-hour time slot in any given date. I want to create a new column in Table 2 that sum up Raw GI value occured in same EpochHH. To create a column, first I used the merge queries option in the power query editor to bring the Raw GI column in Table 2. I brought it the Raw GI value in Table 2 as shown in figure:

image
image1232×869 60 KB

However, when I click on apply and close option, it throws following option:

image
image1369×964 39.3 KB

I checked the Table 2 and it does not contain duplicate value of 110323. I am not sure how to fix the issue. Could you please help me in fixing the issue?
File can be download from EpochHH.pbix (2.0 MB)

2

Hi!
I chekced your file. Since i can’t modify in Power Query. I will tell you what to do.

  1. delete the relationship in Power BI.
  2. Apply changes in Power Query (Merge)
  3. get back to power BI and serach for EpochHH 110323, You will surely find a duplicate.
3

Or you can create a custom column in DAX and add it to Table 2.
As in the example here :

EpochHH.pbix (2.1 MB)

1 Like
4

@HASSAN_BI, Thanks for the reply. I followed the steps: delete the relationship, apply changes to execute the merge. The problem I found is that when I merge, it brings multiple values of 110323 from Table 1 to Table 2 that’s why it is throwing duplicate value issue. Is there any way that I could sum up the value if same Epochh has multiple values when executing merge?

5

@leo_89,
Yes you can sum them by using DAX. Check out the PBIX file i sent.