Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hola Naveen,
No me está dando el resultado correcto cuando estoy usando esta medida en una tabla.
Hola @shashiPaul1570
Pruebe el siguiente DAX.
Avíseme si tiene alguna pregunta o problema.
Si esta publicación ayuda, entonces considere Aceptarlo como la solución para ayudar a los demás a encontrarlo más rápidamente.
Encuentre los datos de muestra.
No_ | Fecha de transacción | Tipo | Importe |
100610 | 10/11/2021 | 2 | 0 |
101311 | 10/11/2021 | 1 | 0 |
101312 | 10/11/2021 | 2 | 78.29 |
101313 | 10/11/2021 | 2 | 260.98 |
101314 | 10/11/2021 | 1 | 0 |
101315 | 10/11/2021 | 2 | 0 |
101316 | 10/11/2021 | 1 | 0 |
101317 | 10/11/2021 | 1 | 0 |
101318 | 10/11/2021 | 1 | 0 |
101319 | 10/11/2021 | 2 | 0 |
101320 | 13/12/2021 | 1 | 78.29 |
101321 | 13/12/2021 | 1 | 260.98 |
101322 | 13/12/2021 | 1 | 182.68 |
101323 | 10/11/2021 | 1 | 0 |
101324 | 10/11/2021 | 0 | 0 |
101325 | 10/11/2021 | 0 | 0 |
101326 | 10/11/2021 | 0 | 0 |
101327 | 10/11/2021 | 2 | 0 |
101328 | 10/11/2021 | 2 | 0 |
101329 | 10/11/2021 | 2 | 0 |
101730 | 10/11/2021 | 2 | 0 |
101731 | 10/11/2021 | 2 | 0 |
101932 | 10/11/2021 | 2 | 0 |
102133 | 10/11/2021 | 2 | 0 |
102134 | 10/11/2021 | 2 | 0 |
102135 | 10/11/2021 | 0 | 0 |
102136 | 10/11/2021 | 0 | 0 |
102137 | 10/11/2021 | 0 | 0 |
103238 | 10/11/2021 | 2 | 0 |
103239 | 10/11/2021 | 1 | 0 |
103240 | 10/11/2021 | 0 | 0 |
103241 | 10/11/2021 | 0 | 0 |
103242 | 10/11/2021 | 0 | 0 |
103243 | 10/11/2021 | 2 | 0 |
103444 | 10/11/2021 | 1 | 0 |
103445 | 10/11/2021 | 2 | 0 |
103746 | 10/11/2021 | 1 | 0 |
103747 | 10/11/2021 | 2 | 0 |
103848 | 10/11/2021 | 1 | 0 |
103849 | 10/11/2021 | 0 | 0 |
103850 | 10/11/2021 | 0 | 0 |
103851 | 10/11/2021 | 0 | 0 |
103852 | 10/11/2021 | 2 | 0 |
103953 | 10/11/2021 | 1 | 0 |
103954 | 10/11/2021 | 0 | 0 |
103955 | 10/11/2021 | 0 | 0 |
103956 | 10/11/2021 | 0 | 0 |
104057 | 10/11/2021 | 1 | 0 |
104058 | 10/11/2021 | 1 | 0 |
104059 | 10/11/2021 | 2 | 0 |
104060 | 10/11/2021 | 1 | 0 |
104161 | 10/11/2021 | 2 | 0 |
104162 | 10/11/2021 | 2 | 0 |
104263 | 10/11/2021 | 2 | 0 |
104264 | 10/11/2021 | 2 | 0 |
104265 | 10/11/2021 | 0 | 0 |
104266 | 10/11/2021 | 1 | 0 |
104267 | 10/11/2021 | 0 | 0 |
104268 | 10/11/2021 | 0 | 0 |
104269 | 10/11/2021 | 0 | 0 |
104270 | 10/11/2021 | 2 | 0 |
104571 | 10/11/2021 | 1 | 0 |
104572 | 10/11/2021 | 0 | 0 |
104573 | 10/11/2021 | 0 | 0 |
104574 | 10/11/2021 | 0 | 0 |
104575 | 10/11/2021 | 2 | 0 |
104676 | 10/11/2021 | 2 | 0 |
104777 | 10/11/2021 | 2 | 0 |
104978 | 10/11/2021 | 2 | 0 |
104979 | 10/11/2021 | 0 | 0 |
104980 | 10/11/2021 | 0 | 0 |
104981 | 10/11/2021 | 0 | 0 |
105082 | 10/11/2021 | 1 | 0 |
105083 | 10/11/2021 | 0 | 0 |
105084 | 10/11/2021 | 0 | 0 |
105085 | 10/11/2021 | 0 | 0 |
105086 | 10/11/2021 | 2 | 0 |
105487 | 10/11/2021 | 1 | 0 |
105488 | 10/11/2021 | 2 | 0 |
105689 | 10/11/2021 | 2 | 0 |
105690 | 10/11/2021 | 0 | 0 |
105691 | 10/11/2021 | 0 | 0 |
105692 | 10/11/2021 | 0 | 0 |
105693 | 10/11/2021 | 2 | 0 |
105694 | 10/11/2021 | 0 | 0 |
105695 | 10/11/2021 | 0 | 0 |
105696 | 10/11/2021 | 0 | 0 |
105797 | 10/11/2021 | 2 | 0 |
105798 | 10/11/2021 | 0 | 0 |
Hola @shashiPaul1570
¿Puede proporcionar datos de muestra y la salida deseada para comprender mejor el problema?
Gracias
Naveen