Divide if in power pivot

[BORUCH]

I Seem to Be Having a Hard Time with Dividing One Column by Another Column in Power Pivot When I Add an If Statement. I Would Like to Divide Column a by Column B If Column C Is Grater Then 0

Any Help Is Appreciated

 

[BORUCH]

Any help please ?

 

[akice]

As a calculated column (if that is what you want), then it is a simple:

= IF ( Table[Column_C] > 0, DIVIDE( Table[Column_A], Table[Column_B] ) )

if in a pivot and you have rows/columns the way you want then :

IF( [Sum of C] > 0, DIVIDE ( [Sum of A], [Sum of B] ) )

 

[BORUCH]

Any help please ?

thanks a million

that worked perfectly

i'm wondering if you can help me with a power piviot calculated column, or field, that would show me the difference in one customers if sales are up or down i would like to be able to filter my sales table by 1 customers and i want it to show me the difference between this month or last year however i slice it