Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Buenas tardes.
Mi modelo de datos tiene las siguientes columnas:
deuda/numero, monto_maximo_pesos, fecha_ingreso, fecha_devuelto
La realidad es que por cada deuda/numero, tengo varias filas con distintos monto_maximo_pesos, fecha_ingreso, fecha_devuelto.
Yo quiero sumar un unico monto por deuda/numero, contando unicamente el primero ordenado por fecha_ingreso.
Estoy intentando hacer esto con FIRSTNOBLANK pero el orden que le da, segun fecha_ingreso parece aleatorio. Es posible ordenar la tabla antes de encontrar el primer valor? (desde Power Query no he podido hacerlo, ya que son millones de regristros)
Desde ya muchas gracias:
Solved! Go to Solution.
@fedeg , I am not sure about the need for a date filter. Most for such join date/calendar table should be disconnected
You can use Index Function for 1st value
calculate(Min(Table['TABLA'[monto_maximo_pesos]]), index(1, allselected('TABLA'[Numero/Deuda],'TABLA'[fecha_ingreso]), orderBy('TABLA'[fecha_ingreso], desc) ,partitionBy('TABLA'[Numero/Deuda])))
Continue to explore Power BI Index function: Top/Bottom Performer by name and value- https://youtu.be/HPhzzCwe10U
Filter are attached two different ways to handle two dates
Hi @fedeg ,
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
@fedeg , I am not sure about the need for a date filter. Most for such join date/calendar table should be disconnected
You can use Index Function for 1st value
calculate(Min(Table['TABLA'[monto_maximo_pesos]]), index(1, allselected('TABLA'[Numero/Deuda],'TABLA'[fecha_ingreso]), orderBy('TABLA'[fecha_ingreso], desc) ,partitionBy('TABLA'[Numero/Deuda])))
Continue to explore Power BI Index function: Top/Bottom Performer by name and value- https://youtu.be/HPhzzCwe10U
Filter are attached two different ways to handle two dates
User | Count |
---|---|
120 | |
66 | |
66 | |
57 | |
50 |
User | Count |
---|---|
176 | |
83 | |
68 | |
65 | |
54 |