This blog show how to get the location where the data is partitioned using the Partition function name

$PARTITION.partition_function_name(expression)