El objetivo es crear una medida de la diferencia entre cualquier fecha en la columna Fecha y 10/01/2020. Estoy recibiendo un error en el primer paso... no está seguro de por qué el cálculo no acepta el campo Fecha.
El resultado final se verá algo parecido (pero con las sintaxis correctas):
Días hasta el 10/01/2020 - 'Tendencia diaria'[Fecha]-10/01/2020
@diogobraga2 - Prueba:
Días hasta el 10/01/2020 á (DATE(2020,10,1) - 'Daily Trend'[Fecha]) * 1.
O
Días hasta el 10/01/2020 á (DATE(2020,10,1) - MAX('Daily Trend'[Date])) * 1.
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)
DAX is easy, CALCULATE makes DAX hard...
Hola @diogobraga2
Yo usaría datediff https://docs.microsoft.com/en-us/dax/datediff-function-dax
ColumnDiff - DATEDIFF('Tendencia diaria'[Fecha] ), DATE(2020,01,10), Día )
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 |
@diogobraga2 - Prueba:
Días hasta el 10/01/2020 á (DATE(2020,10,1) - 'Daily Trend'[Fecha]) * 1.
O
Días hasta el 10/01/2020 á (DATE(2020,10,1) - MAX('Daily Trend'[Date])) * 1.
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)
DAX is easy, CALCULATE makes DAX hard...
Helpful resources
Power BI Monthly Update - April 2024
Check out the April 2024 Power BI update to learn about new features.
Fabric Community Update - April 2024
Find out what's new and trending in the Fabric Community.
