Being fairly new to PowerPivot, I have come across a problem that I have not managed to solve using google tutorials. While I haven't helped other people on this forum (although, any PowerPivot advice from me should at the very least be treated with suspicion), I hope you are willing to help me out:
I am trying to copy temperature data for unique timestamps from one file, to matching non-unique timestamps in another file. The following two screenshots might make this clearer:
This file has the unique timestamps ('DatumUurblok') and the temperature data ('Temperatuur op ... waarneming')
This table has (some of) the same timestamps (again labelled 'DatumUurblok'), but now they are not unique. What I would like is to get the temperature measures from the first table, under the red arrow in the second table when the timestamps match. So, for instance, in the first empty cell of the 'Temperatuur' column in the second file, I want to get the temperature from the first table when the timestamp was exactly '4169907'. In the second, third and fourth empty 'Temperatuur' cell, I should get the same temperature value. The fifth empty cell has a different timestamp, and should therefore be matched to a different temperature.
I hope it is now clear what I am looking for.
Of course, I have attempted to solve this by myself, but formulas using 'Calculate', 'LookUpValue', or 'If' don't seem to work for me (I'm guessing Calculate should work, but it isn't working for me somehow). Can someone please help me out?
Many thanks in advance,
Willem
I am trying to copy temperature data for unique timestamps from one file, to matching non-unique timestamps in another file. The following two screenshots might make this clearer:
This file has the unique timestamps ('DatumUurblok') and the temperature data ('Temperatuur op ... waarneming')
This table has (some of) the same timestamps (again labelled 'DatumUurblok'), but now they are not unique. What I would like is to get the temperature measures from the first table, under the red arrow in the second table when the timestamps match. So, for instance, in the first empty cell of the 'Temperatuur' column in the second file, I want to get the temperature from the first table when the timestamp was exactly '4169907'. In the second, third and fourth empty 'Temperatuur' cell, I should get the same temperature value. The fifth empty cell has a different timestamp, and should therefore be matched to a different temperature.
I hope it is now clear what I am looking for.
Of course, I have attempted to solve this by myself, but formulas using 'Calculate', 'LookUpValue', or 'If' don't seem to work for me (I'm guessing Calculate should work, but it isn't working for me somehow). Can someone please help me out?
Many thanks in advance,
Willem
