Need Help with KPI Visual

[Anonymous]

Hi,

I am trying to build a KPI visual that evaluates a daily production stream (from Table A) against a monthly target volume provided from a different table (Marketing Table)

The Marketing Table is currently provided as a pivot summary from excel that has Month (in Date Format i.e. 1/1/2019 for January), the Purchaser and the target volume.

I am currently editing this data in query editor to read in as:

What doesn't seem to be happening is it isn't pulling the target volume for the current sliced month.

I related the Date/Month to my Date table and the Purchaser column to my Source Asset table for aggregation purposes.

I am needing some extra assistance on getting this target volume to read in appropriately and am stuck

[Anonymous]

HI @Anonymous,

Actually, I'd like to suggest you share more contents to help us clarify your scenario, it is hard to coding formula and troubleshoot from snapshot.

BTW, if you mean you want to create dynamic calculated column/table based on slicer/filter, it is impossible.

Regards,
Xiaoxin Sheng