How to Calculate Percentage of each row element in ADF which uses Sum of all elements present in a particular column in mapping data flow Azure Data Factory ?

Aniket Ghodinde 1 Reputation point

I need to calculate percentage of each row element, with respect to column total. I did aggregate transformation and found TOTAL of particular column but I am not able to used it derived column transformation to find percentage.
I tried to used Cache Lookup and dataflow parameter but it didn't work.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,933 questions
{count} votes