Transactions per machine between first day of operation and next 90 days

[Anonymous]

I am currently analyzing transaction-statistics at the company I'm working for. We have a lot of machines that has different first dates of operation (i.e. one has first date of operation 02.03.17 and another has 04.03.20). We wish to get some insight in how the development of transactions per machine is in the first 90 days of operation and to see if there is differences between the machines.

I have used this DAX-formula to calculate the total number of transactions between the first operation date and the first 90 days in operation: 

Operation date +90 = Calculate([total no of transactions], DATESINPERIOD(Datetable[Date], FIRSTDATE('dimNode')[operation_date],90,DAY))

With the DAX-formula above I am able to see the number of transactions on an aggregated level of the whole period.

Now I want to see the day-by-day accumulated development in transactions in this period to compare the development on the different machines. The goal is to be able to visualize this in different diagrams where it is possible to filter out specific machines. 

[stevedep]

Lift the date filter all( date), add one: date m< min(date) + 90 dates (less than that date)

[harshnathani]

HI @Anonymous ,

You can try this measure

Measure =
CALCULATE (
    [total no of transaction]
    DATESINPERIOD ( 'Calendar'[Date], MIN ( 'Calendar'[Date] ), 90, DAY )
)

Regards,

Harsh Nathani

[Anonymous]

Thank you for the answer @harshnathani , but this gives me the same result as the DAX-formula I outlined in the first post, which is calculating the number of transactions for the whole period and then I can filter per machine/location.

What I am trying to extract is the day-by-day accumulation of transactions within the timeperiod of the first 90 days for each machine, so that I can compare the development for specific machines.

I am not sure if I have to change the DAX-formula I already have to be able to do this or if I only need to create a new measure.

[Anonymous]

@Thejeswar @harshnathani 
Do you know how to do this? Please see previous posts to get to know the problem.

[harshnathani]

Hi @Anonymous ,

Can you share some sample data ?

Regards,

HN

[Anonymous]

Of course @harshnathani 

Using the formula I outlined in a previous post I've managed to get these results:

Machine-ID	Number of transactions the first 90 days in operation
Machine-XXX	90 832
Machine-XXX	70 111
Machine-XXX	42 000

What I would like to be able to do is to see/visualize in a diagram how the curve/development of transactions per machine occurs day-by-day/week-by-week within this time-period and to compare the different machines. In example I want to be able to drag and drop different machines by location and compare specific machines (i.e. machines in the same geographical area). 

The DAX-formula I've used to get number of transactions the first 90 days of operation is this: 

Transactions operation date +90 = CALCULATE([total no of transactions],DATESINPERIOD(Dates[Date],FIRSTDATE(dimNode[operation_date]),90,DAY))