Forum Discussion
Solved
% Difference between two date value
How to get % Change between current Week and Previous Week? Any solution ?
It gives me correct values
Did you try this formula
Column = VAR Priorday = CALCULATE ( MAX ( TableName[Week] ), FILTER ( ALL ( TableName ), TableName[Week] < EARLIER ( TableName[Week] ) ) ) RETURN DIVIDE ( TableName[Conversions], CALCULATE ( SUM ( TableName[Conversions] ), FILTER ( TableName, TableName[Week] = Priorday ) ) ) - 1
Hi sewaktamang
Please try with this minor modification (HIghlighted in RED below)
Colum =
VAR Priorday =
PREVIOUSDAY ( TableName[Week] )
RETURN
DIVIDE (
TableName[Conversions],
CALCULATE (
SUM ( TableName[Conversions] ),
FILTER ( ALL ( TableName ), TableName[Week] = Priorday )
)
)
- 1Hi sewaktamang
My apologies.
Please use this formula
This will get you correct results
Column = VAR Priorday = CALCULATE ( MAX ( TableName[Week] ), FILTER ( ALL ( TableName ), TableName[Week] < EARLIER ( TableName[Week] ) ) ) RETURN DIVIDE ( TableName[Conversions], CALCULATE ( SUM ( TableName[Conversions] ), FILTER ( TableName, TableName[Week] = Priorday ) ) ) - 1PREVIOUSDAY ( TableName[Week] )
THis is giving Empty Column
my mistake. PreviousDays do not exist since there are gaps in dates
Please use the revised formula. I provided above. It shall work hopefully
It is giving me date value :(
Column
Friday, 29 December 1899 Saturday, 30 December 1899 Saturday, 30 December 1899 Saturday, 30 December 1899 Saturday, 30 December 1899