Could you please help me to calculate a measure in Excel 2013 Power Pivot that should show what % of a user acquisition target was achieved? Please see the URL below for the images of a desired output and available tables with raw data that are used in Power Pivot and are related through the codes columns. The problematic measures that I am trying to figure out are highlighted in yellow.
Images of tables
The problem is that targets and actual numbers have different granularity levels (actual data per day for every code in a channel vs targets per month for every channel). Also as the table with target values do not have codes I could not figure out how to relate it to other tables.
Thank you!
Images of tables
The problem is that targets and actual numbers have different granularity levels (actual data per day for every code in a channel vs targets per month for every channel). Also as the table with target values do not have codes I could not figure out how to relate it to other tables.
Thank you!