Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
77 | |
75 | |
67 | |
65 | |
47 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
65 |