Forum Discussion
Syndicate_Admin
Administrator
AdministratorCumulative Total Per Hour
Hello again Sorry for the inconvenience, I have another question, I have a total of consultations in a period of one month, let's say 1000, however, at the end of that time, I need to know how ma...
amitchandak
Super User
Super UserSyndicate_Admin , Create a date time in your table with hour only
date hour = datevalue([Datetime]) +time( hour([Datetime]),0,0)
then a measure like
calculate(sum(Table[value]), filter(allselected(Table[Datehour]), Table[datehour]<= max(Table[Datehour]) ) )
Syndicate_AdminAdministrator
AdministratorRefers to Create a table,
You will create a table like this.
Then you have to format the Column (hours).
After that you will be ready to create the measurement.
AcumHoras =
WHERE CALCULATE =
CALCULATE(
COUNTROWS(
TablaX
)
,FILTER(ALL(TablaX)
,TablaX[Time] <= .MAX(TablaHoras[Hours])
)
)
RETURN CALCULATE
Slds.