Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hola a todos
Tengo datos de la siguiente manera:
Fecha MonthnYear
1/7/2020 de julio de 2020
2/7/2020 de julio de 2020
3/7/2020 de julio de 2020
4/7/2020 de julio de 2020
5/7/2020 de julio de 2020
6/7/2020 de julio de 2020
1/8/2020 Ago 2020
2/8/2020 Ago 2020
3/8/2020 Ago 2020
4/8/2020 Ago 2020
6/8/2020 Ago 2020
8/8/2020 Ago 2020
8/8/2020 Ago 2020
Tengo mis medidas de valores de fecha máximo de la siguiente manera:
Solved! Go to Solution.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Tu dax está casi listo. Usar a continuación cambio
Formatted Max Date=
VAR MaxDate = MAX('Date Table (Actuals)'[Date])
VAR MaxDateAll = CALCULATE([MaxDate], ALL('Date Table (Actuals)'))
RETURN
FORMAT(MaxDateAll,"MMM YYYY")
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Hola @shekhar_123
Tratar
FORMAT(MAX('Tabla de fechas (reales)'[Fecha]),"mmmm AAAA")
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
Esto funciona, pero también necesito todo, para ignorar el filtro de nivel de fila en mis objetos visuales
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
2 | |
2 | |
2 | |
2 | |
1 |