User Profile
NeroTolentino
Frequent Visitor
Joined 7 years ago
User Widgets
Contributions
Show Value of Previous Non Blank if Filter Selected Has No Value
Hello, Hope you can help me with a solution. I need to get the Last Non Blank Value. In the images below, I need Image 2 to show 89.00%, since it has the most recent non blank value. Same if I filter to Dec-2022, I'd like the card to show the most recent non blank which is Jun-2022 score. Image 3 shows the model. The closest solution I found is using LastNonBlank Date but the fields came from the same table so I wasn't able to get the desired solution. Here the PBI_File for reference. Thanks in advance! Image 1 Image 2 Image 3Re: Q > Columna calculada utilizando registro de la fila anterior
@jthomson , @lit2018pbi ; Gracias por investigar esto. Hice ambas cosas, pero creo que falta un paso extra. No puedo simplemente hacer el truco anterior y el truco de índice ya que cada fila de esa columna depende del resultado de la fila anterior. Espero que la imagen de abajo le ayude. Necesito crear una Columna Calculada (columna D) en la imagen, usando la fórmula en la columna E.Re: Q > Calculated Column using record from previous row
jthomson , lit2018pbi ; Thanks for looking into this. I did both but I think it's missing an extra step. I cannot simply do the earlier and index trick since each rows in that column is dependent on the result of the previous row. I hope the image below will help. I need to create a Calculated Column (column D) in the picture, using the formula in column E.
