Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Reverse trend curve

Hi

 

I`m trying to create a reverse trend curve.

 

You start count remaining orders in cutoffweek 19-13 and reach 0 by cutoffweek 19-36.

 

The red curve is a measure: 

CALCULATE( COUNTA(XX[ORDER])- COUNTA(XX[PROGRESS > 80]);USERELATIONSHIP('DateTable'[DateKey];XX[WeekEndDate]))
 
Weekenddate is cutoffdate.
 
I appreciate some help. Thanks.
 
Rgds
Henrik

 

 

No Replies