Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

¿Por qué mi promedio móvil traza fechas/valores futuros?

Hola a todos

Tengo una medida media móvil que funciona para fechas antiguas, pero por alguna razón traza valores para fechas que aún no han sucedido. Mi medida está a continuación usando LastDate, si alguien pudiera echar un vistazo sería apreciado.

Alerón

jme1calff_1-1600788696476.png

Atentamente

Jordania

1 ACCEPTED SOLUTION

@jme1calff Lo sentimos, no vi su código originalmente ya que se contradió en Spoiler (usar bloque de código la próxima vez </>)

EventType 7 Day Rolling Average =
VAR __Calc =
IF (
    ISFILTERED ( 'Date'[Date] ),
    ERROR ( "Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column." ),
    VAR __LAST_DATE =
        LASTDATE ( 'Date'[Date].[Date] )
    RETURN
        AVERAGEX (
            DATESBETWEEN (
                'Date'[Date].[Date],
                DATEADD ( __LAST_DATE, -6, DAY ),
                DATEADD ( __LAST_DATE, 0, DAY )
            ),
            CALCULATE ( COUNTA ( 'Agent Data'[EventType] ) )
        )
)
RETURN
  IF(MAX('Date'[Date])>TODAY(),BLANK(),__Calc)


@ 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!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

5 REPLIES 5
Syndicate_Admin
Administrator
Administrator

Hola @jme1calff ,

¿Se ha resuelto su problema? La fórmula de Greg parece que funciona.

Si funciona, marque la respuesta como solución. Si no, por favor háganoslo saber.

Saludos

Jay

Greg_Deckler
Super User
Super User

@jme1calff - Prueba algo como:

Measure =
  VAR __Calc = <rolling average calculation>
RETURN
  IF(MAX([Date])>TODAY(),BLANK(),__Calc)

@ 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!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

Hola @Greg_Deckler ,

Gracias por volver arme. ¿No entiendo cómo funciona esto?

Atentamente

Jordania

@jme1calff Lo sentimos, no vi su código originalmente ya que se contradió en Spoiler (usar bloque de código la próxima vez </>)

EventType 7 Day Rolling Average =
VAR __Calc =
IF (
    ISFILTERED ( 'Date'[Date] ),
    ERROR ( "Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column." ),
    VAR __LAST_DATE =
        LASTDATE ( 'Date'[Date].[Date] )
    RETURN
        AVERAGEX (
            DATESBETWEEN (
                'Date'[Date].[Date],
                DATEADD ( __LAST_DATE, -6, DAY ),
                DATEADD ( __LAST_DATE, 0, DAY )
            ),
            CALCULATE ( COUNTA ( 'Agent Data'[EventType] ) )
        )
)
RETURN
  IF(MAX('Date'[Date])>TODAY(),BLANK(),__Calc)


@ 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!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

Hola Greg,

Puedo confirmar que esto ahora funciona, gracias por esto!

image.png

Atentamente

Jordania

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors