

February 1, 2019

Hi,
i have source table and Table to join like in screens attached.
For each key i can have different OS Disk Sizes, in this case they are the same = 1024.
For server1 key i added one additional row in table "Table to join" which i want to create in power query (this row doesnt exists in "Table to join" source table, i want to add it).
I want to use OsDiskSize value from Source table for specific Key and Tier group and add this as MountPoint in order to sum this to all aggregated and summed up Server-Tier Group-DiskSize values in Table to join.
So goal is to sum up All Servers disk sizes for specific Tier Group but add only once OsDiskSize value to them.
please help,
best,
Jacek


1 Guest(s)
