4 Replies Latest reply on Aug 29, 2018 3:35 PM by Esther Aller

# % Difference Between 2 Dates

Hi community

i am learning alot as i go along,

i am trying to create a mini dashboard to calculate the % difference in values between 2 dates. I have created a filter for relative dates.

how do i create a another measure to do that ? i know how to do that in a table but in this case i do not have the 2 values on the same table but yet need to show it on a dashboard for a mobile phone....

• ###### 1. Re: % Difference Between 2 Dates

hi Gavin,

Refer

Thanks

sankar

• ###### 2. Re: % Difference Between 2 Dates

Hi Gavin,

Create  a calculation like below

You will get the % difference

Result:

Hope this helps

BR,

NB

• ###### 3. Re: % Difference Between 2 Dates

wow nice

why does this work? could you explain what you did with the calculated field

(

{ sum(if DATEDIFF('week',[Order Date],today())=0 then [Sales] end)}

-

{ sum(if DATEDIFF('week',[Order Date],today())=1 then [Sales] end)}

)

/

{ sum(if DATEDIFF('week',[Order Date],today())=0 then [Sales] end)}

I realised that it doesnt work if i throw in more filters.....

• ###### 4. Re: % Difference Between 2 Dates

Hi Gavin,

The {...} syntax is shorthand for { FIXED : ... }. The level of detail (LOD) function fixed will return the result of the specified expression over the entire data set. By design FIXED calculations ignore filters.

These articles explain in further detail: