Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Guys,
I have a requirement; I need to se the newest date of a page base in the value of a segmentation.
In this page, I would like to get the
oldest or newest date; in this instance, according to the segmentation, the last date is 21/10/2020, but with the formula MAX(Fecha[Fecha]) the obained value is 12/05/2021, wich is the oldest of all data; is there a way with DAX to get the interval oldest 21/10/2020 and the newest (06/04/2020? The idea is to get the date updated every single time that I change the values in slicer. Any suggestion?
Thanks a lot, regards,
Abelardo
Solved! Go to Solution.
Hola Abelardo, de acuerdo con el nombre de tu medida, asumo que hablas español.
Esto debe funcionar de forma nativa, sin embargo, quisiera validar contigo lo siguiente:
De ser asi, estos son 3 ejemplos que puedes tener en cuenta.
Ejemplo
Adjunto el PBIX
https://iwco.blob.core.windows.net/jbocachica/Ejemplo maximo fechas.pbix
Hola Abelardo, de acuerdo con el nombre de tu medida, asumo que hablas español.
Esto debe funcionar de forma nativa, sin embargo, quisiera validar contigo lo siguiente:
De ser asi, estos son 3 ejemplos que puedes tener en cuenta.
Ejemplo
Adjunto el PBIX
https://iwco.blob.core.windows.net/jbocachica/Ejemplo maximo fechas.pbix
Correcto John, la segunda solución es la que estaba buscando, porque necesito ese valos para incluirla en otra medición.
Gracias, saludos,
Abelardo
Hi @Abevann ,
does the slicer get the dates from the same column as your measure Utimo dia?
With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)
Hi Frank, correct, I want to use this value to calculate another value dinamically with the slicer... I'm using FIRSTDATE and seems to work better, but still working on it... thanks
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
71 | |
70 | |
38 | |
26 | |
26 |
User | Count |
---|---|
100 | |
87 | |
45 | |
43 | |
35 |