HELP Counting the Amount of Date Periods Per Sales Order

[cfurminger]

Hi, 

Need some help with this. 

I need a running total for the amount of instances in each Sales Order, in my example I have highlighted the 3 main varaibles. 

(Sales Orders, Date of Change and my Solution)

However my solution is only giving me the amount of lines in each Sales Order. 

My answer for 2 lines = 2,2 and for 3 lines = 3,3,3.

Number of orders per Orders = COUNTX (

FILTER ( 'System Note Dataset COREY TEST (2)', EARLIER('System Note Dataset COREY TEST (2)'[Record] ) = 'System Note Dataset COREY TEST (2)'[Record]),

'System Note Dataset COREY TEST (2)'[Record]

)

But I want it to start at 1 and count the amount of lines per Sales Order. 

2 lines = 1,2 and for 3 lines = 1,2,3 etc. etc. 

Any help would be amazing!

Corey

[v-jingzhang · Accepted solution]

Hi @cfurminger 

You can try this DAX:

Number of orders per Orders = COUNTX (
FILTER ( 'System Note Dataset COREY TEST (2)', EARLIER('System Note Dataset COREY TEST (2)'[Record] ) = 'System Note Dataset COREY TEST (2)'[Record] && EARLIER('System Note Dataset COREY TEST (2)'[Date]) >= 'System Note Dataset COREY TEST (2)'[Date] ),
'System Note Dataset COREY TEST (2)'[Record]
)

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[cfurminger]

@amitchandak