Calculation between same measure

[cristianml]

Hi,

I need to do a calculation between number from a same measure. 

__Revenue / Workday 2 = [__Rev] / [__NWD]

 Per example: I need to do :

31.30 / 28.59  -1

28.59 / 25.16 -1 

25.16 /  23.54 -1 

an so on 

But this table doesn't have DATES. The FY & Q is a text format. And only have FY as a whole number and a quarter Column:

Any idea ?

[amitchandak]

@cristianml ,

Try divide([__Rev] , [__NWD]) -1

or

divide([__Rev] - [__NWD],[__NWD])

[cristianml]

Hi @amitchandak ,

Those numbers I showed in the screenshot are already the results of [__Rev] / [__NWD]

What I need is to divide between that measure ..  So you can understand in code :

Divide  >      ([__Revenue / Workday 2]) /  [__Revenue / Workday 2]) - 1

I need this calculation one against previous one BUT it doesn't have DATE column. I explaIned this above.