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

 

Weird, could you post a snippet of the data that you're working with?

 

Thanks,

Parker

RVBalazs's avatar
RVBalazs
New Member
8 years ago

 

Anonymous here is a snippet of the data, with the two columns i'm trying to read in red.

 

Yemeng_Hu the Dates values goes between 01-2017 to 09-2017

  • 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?