Forum Discussion

chrisgehm's avatar
chrisgehm
Helper III
9 years ago
Solved

Divide 2 columns

Hi!   I've got a simple table in excel, where I have Name, Amount1 and Amount2   I need to show in PBI the diference betwen both and after that, I need to divide the diference with Amount1. Th...
Need Help
  • Sean's avatar
    Sean
    9 years ago

    You need to use only MEASURES for this! :smileyhappy:

     

    Amt1 Total = SUM('Table'[Amount1])

Amt2 Total = SUM('Table'[Amount2])

Difference = [Amt1 Total] - [Amt2 Total]

Divide = DIVIDE ( [Difference], [Amt1 Total], 0 )
chrisgehm's avatar
chrisgehm
Helper III
9 years ago

Sean it is still calculating wrong :(

 

BarrbC's avatar
BarrbC
Frequent Visitor
8 years ago

I have similar challenge. I followed the formula as in the case described. However, PBI doesn't show the results: only 2 distinct values 0 and 1. what could be the reason for that?

 

and what is more important I created a measure for that  

DIVIDE(calculate(sum('DB Data'[Sales CY YTD $])- sum('DB Data'[Sales_PY_YTD_$])),sum('DB Data'[Sales_PY_YTD_$]),0 ) and it works. 

How to reflect it as a calculated column? Equation doesn't help