SQL Server Transact Basic to Expert - Get location of data in the partition

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

$PARTITION.partition_function_name(expression)