Forum Discussion

RVBalazs's avatar
RVBalazs
New Member
8 years ago
Solved

[Help] "The syntax for 'interval' is incorrect"

Hi, sorry if this is repeated, but i can't find  a solution in other post. I'm new in Power BI.   I'm getting this error for almost every time intelligence function i'd tried, allways in the inter...
  • RVBalazs's avatar
    RVBalazs
    8 years ago

    Finally i make it work, don't know how or why haha
    but on the time intelligence functions i leave a space between the parameters <number_of_intervals> and <interval>

    Periodo = CALCULATE ( 
            sum('adm_dandtab MedicionesLimites'[Cantidad]), 
            PARALLELPERIOD( 'adm_dandtab Limites'[Fecha].[Date], 1, , MONTH )
            )

    with this it works fine

Anonymous's avatar
Anonymous
Not applicable
8 years ago

RVBalazs

 

Not sure if this will help, but can you try:

 

Periodo = CALCULATE ( 
            sum('adm_dandtab MedicionesLimites'[Cantidad]), 
            DATESINPERIOD('adm_dandtab Limites'[Fecha], FIRSTDATE('adm_dandtab MedicionesLimites'[Fecha]), 1, MONTH)
            )

 

Note: I took off the .[Date] and changed Fecha_Mes to Fecha. I also added FIRSTDATE.

 

Let me know if that helps

Parker 

RVBalazs's avatar
RVBalazs
New Member
8 years ago

Finally i make it work, don't know how or why haha
but on the time intelligence functions i leave a space between the parameters <number_of_intervals> and <interval>

Periodo = CALCULATE ( 
            sum('adm_dandtab MedicionesLimites'[Cantidad]), 
            PARALLELPERIOD( 'adm_dandtab Limites'[Fecha].[Date], 1, , MONTH )
            )

with this it works fine

  • katoma's avatar
    katoma
    Regular Visitor
    8 years ago

    Could anyone at powerbi please fix the parser and/or the documentation for datesinperiod a.s.o?