SELECT *
FROM your_table
WHERE
    Prod_Site = "Y"
    and Wk = '49-2025'
QUALIFY ROW_NUMBER() OVER (
            PARTITION BY Initiative, PO_FPC, PI_FPC, Countries, Loc
            ORDER BY PublishTimestamp DESC
        ) = 1),

and more

select count(*) from (SELECT *
FROM your_table
WHERE
    PublishTimestamp >= DATE_TRUNC('WEEK', CURRENT_DATE())
    AND PublishTimestamp < DATE_ADD(DATE_TRUNC('WEEK', CURRENT_DATE()), 3) AND
    Prod_Site = "Y"
QUALIFY ROW_NUMBER() OVER (
            PARTITION BY PO_FPC
            ORDER BY PublishTimestamp DESC
        ) = 1
        )