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
Recommendations
Subject | Author | Posted | |
---|---|---|---|
06-07-2022 10:44 PM | |||
03-08-2022 06:00 AM | |||
01-16-2021 01:40 AM | |||
09-13-2023 01:02 AM | |||
01-13-2022 05:36 AM |
Featured Topics
Top Kudoed Authors (Last Month)
User | Count |
---|---|
106 | |
88 | |
82 | |
54 | |
46 |