Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Buenos días
¿Cómo puedo crear un promedio móvil de recuento de entradas diarias utilizando la siguiente tabla como origen.
Gracias de antemano por su ayuda.
Fecha de creación |
4/1/2020 1:49 |
4/1/2020 15:17 |
4/1/2020 16:04 |
4/1/2020 17:00 |
4/1/2020 17:13 |
4/1/2020 17:38 |
4/1/2020 17:43 |
4/1/2020 17:44 |
4/1/2020 17:50 |
4/1/2020 18:37 |
4/1/2020 19:07 |
4/1/2020 19:22 |
4/1/2020 20:14 |
4/1/2020 23:07 |
4/1/2020 23:51 |
4/2/2020 2:45 |
4/2/2020 7:18 |
4/2/2020 7:31 |
4/2/2020 19:59 |
4/2/2020 20:18 |
4/2/2020 21:31 |
4/2/2020 21:48 |
4/2/2020 22:11 |
4/3/2020 0:51 |
4/3/2020 0:57 |
4/3/2020 17:09 |
4/3/2020 17:53 |
4/3/2020 18:47 |
4/3/2020 19:49 |
4/3/2020 21:47 |
4/3/2020 21:58 |
4/4/2020 4:18 |
4/4/2020 8:30 |
4/4/2020 15:49 |
4/4/2020 16:19 |
4/4/2020 16:37 |
4/4/2020 17:01 |
4/4/2020 17:03 |
4/4/2020 23:00 |
4/5/2020 0:18 |
4/5/2020 7:27 |
4/5/2020 12:07 |
4/5/2020 16:12 |
4/5/2020 16:46 |
4/5/2020 19:59 |
4/5/2020 21:29 |
4/6/2020 6:56 |
4/6/2020 7:45 |
4/6/2020 17:38 |
4/6/2020 17:41 |
4/6/2020 18:18 |
4/6/2020 18:26 |
4/6/2020 18:39 |
4/6/2020 19:07 |
4/6/2020 19:02 |
4/6/2020 19:18 |
4/6/2020 19:20 |
4/6/2020 20:11 |
4/6/2020 20:42 |
4/6/2020 21:12 |
4/6/2020 22:14 |
4/7/2020 5:08 |
4/7/2020 6:28 |
4/7/2020 20:24 |
4/8/2020 0:37 |
4/8/2020 6:26 |
4/8/2020 23:58 |
4/9/2020 4:19 |
4/9/2020 21:52 |
4/9/2020 23:33 |
4/10/2020 0:22 |
4/10/2020 21:23 |
4/10/2020 21:34 |
4/10/2020 22:14 |
4/10/2020 22:37 |
4/11/2020 0:09 |
4/11/2020 21:52 |
4/12/2020 0:20 |
4/12/2020 3:02 |
4/12/2020 7:43 |
4/12/2020 8:30 |
4/12/2020 10:24 |
4/12/2020 23:10 |
4/12/2020 23:19 |
4/13/2020 2:54 |
4/13/2020 23:28 |
4/13/2020 23:49 |
4/14/2020 7:08 |
4/14/2020 19:30 |
4/14/2020 20:02 |
4/14/2020 20:04 |
4/15/2020 1:51 |
4/15/2020 23:46 |
4/16/2020 0:17 |
4/16/2020 17:39 |
4/16/2020 17:51 |
4/16/2020 19:56 |
4/17/2020 2:04 |
4/17/2020 2:24 |
4/17/2020 17:38 |
4/17/2020 18:14 |
4/17/2020 22:57 |
4/18/2020 3:07 |
4/18/2020 3:13 |
4/18/2020 21:42 |
4/18/2020 22:19 |
4/19/2020 1:24 |
4/19/2020 23:12 |
4/19/2020 23:28 |
Solved! Go to Solution.
se puede tratar de
1. crear una columna de fecha
date = 'Table'[Date Created].[Date]
2. crear una medida
rolling 7 days =
VAR _max=max('Table'[date])
VAR _min=_max-6
return if(_min<MINX(ALL('Table'),'Table'[date]),blank(),DIVIDE(CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'),'Table'[date]>=_min&&'Table'[date]<=_max)),7))
Proud to be a Super User!
se puede tratar de
1. crear una columna de fecha
date = 'Table'[Date Created].[Date]
2. crear una medida
rolling 7 days =
VAR _max=max('Table'[date])
VAR _min=_max-6
return if(_min<MINX(ALL('Table'),'Table'[date]),blank(),DIVIDE(CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'),'Table'[date]>=_min&&'Table'[date]<=_max)),7))
Proud to be a Super User!
@sltraffic , Crear una columna de fecha a partir de la fecha
Fecha de creación : [fecha de creación].time
Unirse a una tabla de fechas y probar una fórmula como
Rolling 7 day á divide(CALCULATE(countrows(Table),DATESINPERIOD('Date'[Date],MAX('Date'[Date]),-7,Day)), CALCULATE(distinctcount(Table[Date Created]),DATESINPERIOD('Date'[Date],MAX('Date'[Date]),-7,Day)) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
1 | |
1 | |
1 | |
1 | |
1 |