Forum Discussion

tamilkumaran's avatar
tamilkumaran
Frequent Visitor
6 years ago

Calculate percentage difference between two column-individual row and difference of column for month

I have a requirement to show the percentage difference between two columns dynamically based on user selection in filter. I am providing 3 individual filters to user as Slicer  - Region, Country, Mo...
Need Help
FrankAT's avatar
FrankAT
Icon for Community Champion rankCommunity Champion
6 years ago

Hi tamilkumaran 

is this what you are searching for?

 

 

Sum of Sales 1 = SUM('Table'[Sales 1])

Sum of Sales 2 = SUM('Table'[Sales 2])

Percentage = DIVIDE([Sum of Sales 2],[Sum of Sales 1])

Regards FrankAT