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...
Need Help
  • martinkoe's avatar
    martinkoe
    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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi martinkoe,

Can you please share some dummy data with a similar data structure and expected results? It should help us clarify your scenario and test to troubleshoot.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng