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.
Hola equipo,
Fecha | Categoría | Valor |
10/18/6061 | Equidad | 0.060695565 |
10/15/6061 | Equidad | 0.06615055 |
10/16/6061 | Equidad | 0.515556657 |
10/15/6061 | Equidad | -0.06055155 |
10/16/6061 | Equidad | -0.66555696 |
10/11/6061 | Equidad | 0.61156187 |
10/8/6061 | Equidad | 0.051511557 |
10/5/6061 | Equidad | 0.860685859 |
10/6/6061 | Equidad | -0.191516616 |
10/5/6061 | Equidad | 0.558910066 |
10/6/6061 | Equidad | 0.055658656 |
10/1/6061 | Equidad | -0.566996667 |
9/50/6061 | Equidad | -0.666506606 |
9/69/6061 | Equidad | 0.560666956 |
9/68/6061 | Equidad | -0.566655652 |
9/65/6061 | Equidad | -0.181656565 |
9/66/6061 | Equidad | 0.569680007 |
9/65/6061 | Equidad | 0.65686568 |
9/66/6061 | Equidad | 0.869566057 |
9/61/6061 | Equidad | 0.91181551 |
9/60/6061 | Equidad | -1.615065561 |
9/15/6061 | Equidad | -0.058655656 |
9/16/6061 | Equidad | -0.586559666 |
9/15/6061 | Equidad | 0.69866606 |
9/16/6061 | Equidad | 0.695616597 |
9/15/6061 | Equidad | 0.595666057 |
9/10/6061 | Equidad | -0.185868681 |
9/9/6061 | Equidad | -1.005595582 |
9/8/6061 | Equidad | -0.698696588 |
10/18/6061 | Comm | 0.100965556 |
10/15/6061 | Comm | 0.518551956 |
10/16/6061 | Comm | 0.005665657 |
10/15/6061 | Comm | -0.665565869 |
10/16/6061 | Comm | 0.595811897 |
10/11/6061 | Comm | -0.066595161 |
10/8/6061 | Comm | 0.865866651 |
10/5/6061 | Comm | 0.590558661 |
10/6/6061 | Comm | 0.606856562 |
10/5/6061 | Comm | -0.066665911 |
10/6/6061 | Comm | -0.566855686 |
10/1/6061 | Comm | -0.569561665 |
9/50/6061 | Comm | 0.556555889 |
9/69/6061 | Comm | -1.680619609 |
9/68/6061 | Comm | -0.681805652 |
9/65/6061 | Comm | 0.556056987 |
9/66/6061 | Comm | 0.506559566 |
9/65/6061 | Comm | 0.866561002 |
9/66/6061 | Comm | 0.966566861 |
9/61/6061 | Comm | -1.655669567 |
9/60/6061 | Comm | 1.061919057 |
9/15/6061 | Comm | -0.666565559 |
9/16/6061 | Comm | 0.516056866 |
9/15/6061 | Comm | 0.566508067 |
9/16/6061 | Comm | 0.616059589 |
9/15/6061 | Comm | -0.18095666 |
9/10/6061 | Comm | -1.000056519 |
9/9/6061 | Comm | -0.656565907 |
Requisito:- Basado en la fecha seleccionada, calcule los valores acumulativos basados en la fórmula a continuación
Necesidad de mostrar el gráfico de líneas en la fecha del eje x y los valores acumulativos y leyendas del eje y como categoría
Saludos
Solved! Go to Solution.
@Anshenterprices , Supongamos que tiene una medida de valor base del valor estático
Cumm =[Valor base] + CALCULATE(SUMA(Tabla[valor]),filter(allselected(Table),Table[Date] <=max(Table[Date]) && Table[category] =max(Table[category]) ))
@Anshenterprices , Supongamos que tiene una medida de valor base del valor estático
Cumm =[Valor base] + CALCULATE(SUMA(Tabla[valor]),filter(allselected(Table),Table[Date] <=max(Table[Date]) && Table[category] =max(Table[category]) ))
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 |
User | Count |
---|---|
2 | |
2 | |
1 | |
1 | |
1 |