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

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