Forum Discussion
data visualization & complex dax measurements
Hi ccastelb,
For the additional question, would you please clarify more details? For exmaple, which column do you want to calculate the average value of it? What's the logic?
Also, does "the days between transfers" mean that the max date intervals for each ticket and each transfer? If right, you may try measure below and check if it can meet your requirement:
Interval = CALCULATE ( MAX ( Table[fecha] ) - MIN ( Table[fecha] ), ALLEXCEPT ( Table, Table[Ticket], Table[from], Table[to] ) )Regards,
Jimmy Tao
Hi ccastelb,
For the additional question, would you please clarify more details? For exmaple, which column do you want to calculate the average value of it? What's the logic?
Also, does "the days between transfers" mean that the max date intervals for each ticket and each transfer? If right, you may try measure below and check if it can meet your requirement:
Interval =
CALCULATE (
MAX ( Table[fecha] ) - MIN ( Table[fecha] ),
ALLEXCEPT ( Table, Table[Ticket], Table[from], Table[to] )
)
Regards,
Jimmy Tao
Thank you very much for your support, I had not returned to this thread due to lack of time and work commitments, but in order to contribute something, even if it is not very express how to solve the case. because I could not find a form of representation that would leave clarity about how the tickets move, what I did was to take the average number of movements a ticket has, after that I took the probability that each ticket was in a certain group in each movement, so for example the probability of entering the group xxxx, then take the probability of the group in the second movement and so on, in the end simply model as a line diagram to represent the linearity of the process.
for the subject of the time of each transfer I had more difficulties in the calculation, I really applied it more manually, I know it is the worst option but I am not more alternative, for that matter take a dynamic table and take maximum and minimum for each line, later average, that I estimate that throws me the amount of days on average that are consumed per ticket.
I know that this solution is not the most orthodox yet I comment it with the encouragement that it serves as a guide for some more brilliant people.
However, since I am not a specialist, if I have made an error, I accept the corrections of the case.
Thank you again for your time and effort.