Forum Discussion

martinkoe's avatar
martinkoe
Helper I
5 years ago
Solved

Visual does not work when published

Hello,   i have created a new measure and it works perfectly in the Desktop version. When i publish the Report, everything works accept this single visual. For sure it has to do with the measure, a...
  • martinkoe's avatar
    5 years ago

    Dear all,

     

    got it, it was an measure error. Nothing to do with gateway, July update whatsoever.

     

    RIGHT:

    Sales PYE total = CALCULATE( [Sales YTD POS], ENDOFYEAR(DATEADD(data[Date],-1,YEAR)))
    Sales YEE = [Sales PYE total]*(1+[Sales growth rate POS])

     

    WRONG:

    Sales YEE = CALCULATE( [Sales YTD POS], ENDOFYEAR(DATEADD(data[Date],-1,YEAR),"31.12"))*(1+[Sales growth rate POS])

     

    //M