Forum Discussion
Anonymous
7 years agoNot applicable
Identify the continuous Increasing Data Points
Hello Experts, I have data points based on a key and date as below- Key Date Datapoint s0012jan 12jan19 15 s0013jan 13jan19 16 s0014jan 14jan19 ...
- 7 years ago
Hi Anonymous ,
Please new measures as below:
check1 = IF ( SUM ( Data_4[Datapoint] ) > CALCULATE ( SUM ( Data_4[Datapoint] ), FILTER ( ALLSELECTED ( Data_4 ), Data_4[Index] = MAX ( Data_4[Index] ) - 1 ) ), 1, 0 ) check2 = VAR start_index = CALCULATE ( MAX ( Data_4[Index] ), FILTER ( ALLSELECTED ( Data_4 ), [check1] = 0 && Data_4[Index] <= MAX ( Data_4[Index] ) ) ) VAR end_index = CALCULATE ( MIN ( Data_4[Index] ), FILTER ( ALLSELECTED ( Data_4 ), [check1] = 0 && Data_4[Index] >= MAX ( Data_4[Index] ) ) ) RETURN IF ( [check1] = 1, IF ( end_index <> BLANK (), SUMX ( FILTER ( ALLSELECTED ( Data_4 ), Data_4[Index] <= end_index && Data_4[Index] > start_index ), [check1] ), SUMX ( FILTER ( ALLSELECTED ( Data_4 ), Data_4[Index] <= MAX ( Data_4[Index] ) && Data_4[Index] > start_index ), [check1] ) ) )Add [Check2] into visual level filter to highlight dates having 6 consecutive data points which are greater than previous.
Best regards,
Yuliana Gu
v-yulgu-msft
7 years agoMicrosoft Employee
Hi Anonymous ,
Please new measures as below:
check1 =
IF (
SUM ( Data_4[Datapoint] )
> CALCULATE (
SUM ( Data_4[Datapoint] ),
FILTER ( ALLSELECTED ( Data_4 ), Data_4[Index] = MAX ( Data_4[Index] ) - 1 )
),
1,
0
)
check2 =
VAR start_index =
CALCULATE (
MAX ( Data_4[Index] ),
FILTER (
ALLSELECTED ( Data_4 ),
[check1] = 0
&& Data_4[Index] <= MAX ( Data_4[Index] )
)
)
VAR end_index =
CALCULATE (
MIN ( Data_4[Index] ),
FILTER (
ALLSELECTED ( Data_4 ),
[check1] = 0
&& Data_4[Index] >= MAX ( Data_4[Index] )
)
)
RETURN
IF (
[check1] = 1,
IF (
end_index <> BLANK (),
SUMX (
FILTER (
ALLSELECTED ( Data_4 ),
Data_4[Index] <= end_index
&& Data_4[Index] > start_index
),
[check1]
),
SUMX (
FILTER (
ALLSELECTED ( Data_4 ),
Data_4[Index] <= MAX ( Data_4[Index] )
&& Data_4[Index] > start_index
),
[check1]
)
)
)
Add [Check2] into visual level filter to highlight dates having 6 consecutive data points which are greater than previous.
Best regards,
Yuliana Gu
Anonymous
7 years agoNot applicable
Hi v-yulgu-msft ,
Thank you so much for solution. If possible, can you explain 'start index' , 'stop index' and final loop of the dax.