Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Anonymous
Not applicable
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Funcionamiento incorrecto de FIRSTNONBLANKVALUE
02-15-2023
07:32 AM
Tengo esta tabla "Prueba PMC-Previo" de valores:
Y creo uno columna calculada:
Fecha Primer PMC = FIRSTNONBLANKVALUE('Prueba PMC-Previo'[PMC], MIN('Prueba PMC-Previo'[Fecha Fichero]))
Y devuelve lo siguiente:
En la fila en rojo ¿porqué no devuelve la fecha 31/03/2018 0:00?
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-15-2023
06:05 PM
@Anonymous , Try like
calculate( MIN ( 'PMC-Previous Test' [File Date] ), not(isblank( 'PMC-Previous Test' [File Date])) )
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-15-2023
06:05 PM
@Anonymous , Try like
calculate( MIN ( 'PMC-Previous Test' [File Date] ), not(isblank( 'PMC-Previous Test' [File Date])) )
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-16-2023
01:30 AM
Hi Mr amitchandak:
Perfect solution. Thank you very much.
Regards, Marcos

Helpful resources
Featured Topics
Top Kudoed Authors (Last Month)
User | Count |
---|---|
136 | |
107 | |
88 | |
58 | |
46 |