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 interval value. for example, in this column:

 

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

Thanks in advance for your time.

  • 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

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hey RVBalazs

     

    I'm going out on a limb here but the second argument in your DATESINPERIOD function is [Fecha_mes] so is this only a month value? I assume this is not a date so you can't use a 1 month interval. Maybe replace that with your [Fecha] column.

     

    Hope this helps,

    Parker

     

     

    • 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

  • Yemeng_Hu's avatar
    Yemeng_Hu
    Frequent Visitor
    8 years ago

    What is the max([Dates]) of your data?

    Time intellegence only can return dates within the [Dates] that you have,  

     

    Since you want to check [Camtodad] in next month, you may not have that in your data. 

     

    +1 means one month later, -1 means one month earlier.  

     

    Thanks,

    Yemeng