User Profile
jovian1511
Copper Contributor
Joined Aug 04, 2023
User Widgets
Recent Discussions
How to merge tables without duplication in columns
I am trying to create dashboard for report. For example, Table 1 is the table with the unique values Project Number and some basic details. Table 1 Then I have the other table, with different sets of data, but the most important part will be, I'll need ALL the data for the pivot table Table 2 However, when I try to merge them in power query, "Forecasted Value" will be duplicated and I will end up with a forecasted value for A1 to be 3000 instead of whats shown in table 1 due to the duplications. Is there a way to merge (Group?) them or I'll have to create another table? Thanks in advance!
