Forum Discussion
Refresh error duplicate values in the table
Forgive me, I'm fairly new to Power BI. How would I go about creating a new key that concatenates the department/date please?
In PowerBI, just create a new calculated column in each table, e.g.
UniqueID = 'Leavers for Turnover'[StartofMonthLeaveDate] & 'Leavers for Turnover'[Positions V2 (2). DepartmentNumber]
You'll need to swap out the table name 'Leavers for Turnover' for the relevant table name when adding it to the other table.
Alternatively you could create the new key in PowerQuery using merge columns see https://support.microsoft.com/en-us/office/merge-columns-power-query-80ec9e1e-1eb6-4048-b500-d5d42d9f0a8d#:~:text=In%20the%20Custom%20Column%20Formula%20box%2C%20enter%20an%20ampersand%20(%26,after%20the%20ampersand%20(%26).
Then once you have your new key in each table you'll need to remap the two tables using the new key in the schema view.
Hi,
Thank you. I've managed to resolve the error so that the refresh is working but I think it's my grouping that's causing issues...
As the table is grouped using StartMonthLeaveDate and Department it's not producing the correct results are there are duplicates for StartMonthLeaveDate. Is there a way to group on StartMonthLeaveDate while retaining Department information please? This is what my grouping looks like currently: