Hi there,
I have my first data source name A which is the excel file and have the "spend" column inside,
then I have my second data source (database) named B which had a blending relationship with an excel file named C, and we are taking spend from the C file but the rest of the measures from B
I want to make a calculation field and call it "Overall Spend" and then bring both Spends from different sources there!
IF [media] = "Search" THEN "Spend" <<<<<<<<<<<< From File A
ELSEIF [Media] = "Display" THEN [file C].[Spend]
END
for both Media is coming from file B
is there any way to do it?
Thank you!
if the data sets are blended the values will come over aggregated at the level of the link - see https://jimdehner.com/2020/03/23/faq-series-order-of-operations/ - if you can create an actual relationship (noodle) it would be better
Jim
