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

RVBalazs's avatar
RVBalazs
New Member
8 years ago

Hi Anonymous.

 

Thanks for answer, and yes, in that example "[Fecha_mes]" is only the month, a bit of desperation haha but before that i tried with the "[Fecha]" column and get the same error,  with manually input dates and the same error, even try to change the "," with ";" and that was worst.

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