Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Buen dia,
Quisiera su apoyo para enumerar las filas segun programa, el programa (D) NUTRISSA-MD se repite "n" veces se enumera de manera ascendiente en la fecha 10/01/2021 debe iniciar el 1 al n y la fecha11/01/2021debe iniciar del 1 al n, asi los demas programas.
Fecha | Programa | Numeración según Programa |
10/01/2021 | (D) NUTRISSA-MD | 1 |
10/01/2021 | (D) NUTRISSA-MD | 2 |
10/01/2021 | (D) NUTRISSA-MD | 3 |
10/01/2021 | (D) LA RICA VICKY-MD | 1 |
10/01/2021 | (D) LA RICA VICKY-MD | 2 |
10/01/2021 | (D) LA RICA VICKY-MD | 3 |
10/01/2021 | (D) LA RICA VICKY-MD | 4 |
10/01/2021 | (D) LA RICA VICKY-MD | 5 |
10/01/2021 | (D) LA RICA VICKY-MD | 6 |
10/01/2021 | (D) LN DESPIERTA CON MATINAL-MD | 1 |
10/01/2021 | (D) LN DESPIERTA CON MATINAL-MD | 2 |
10/01/2021 | (D) LN DESPIERTA CON MATINAL-MD | 3 |
10/01/2021 | (D) LN DESPIERTA CON MATINAL-MD | 4 |
11/01/2021 | (D) NUTRISSA-MD | 1 |
11/01/2021 | (D) NUTRISSA-MD | 2 |
11/01/2021 | (D) NUTRISSA-MD | 3 |
11/01/2021 | (D) LN DESPIERTA CON MATINAL-MD | 1 |
11/01/2021 | (D) YO SOY-NO | 1 |
Solved! Go to Solution.
Hi @DCKarol1999 ,
Inorder to do this, you should add an index column in the table. i recommand do it by power query editor.
Then create a columns via this following code:
Numeración según Programa =
COUNTROWS(
FILTER(
'Table',
[Fecha ] = EARLIER( 'Table'[Fecha ] )
&& [Programa] = EARLIER( 'Table'[Programa] )
&& [Index] <= EARLIER( 'Table'[Index] )
)
)
Result:
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @DCKarol1999 ,
Inorder to do this, you should add an index column in the table. i recommand do it by power query editor.
Then create a columns via this following code:
Numeración según Programa =
COUNTROWS(
FILTER(
'Table',
[Fecha ] = EARLIER( 'Table'[Fecha ] )
&& [Programa] = EARLIER( 'Table'[Programa] )
&& [Index] <= EARLIER( 'Table'[Index] )
)
)
Result:
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@DCKarol1999 , Try a new table like, in case calendar generate name fecha, make sure you have a different name in you table
filter(GENERATE(data1, calendar(eomonth(min(data1[Fecha ]),-1)+1,eomonth(max(data1[Fecha ]),0))), [Date] >= EOMONTH([Fecha ],-1)+1 && [Date] <=[Fecha ])
User | Count |
---|---|
99 | |
90 | |
85 | |
74 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |