Forum Discussion
Measure does not work when published - Year end estimate (YEE)
Dear all,
got it, it was an measure error. Nothing to do with gateway 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
martinkoe , first of check this setting ui, is it asking for any details. Under datasource and credential
Looking at the error, I would advise to an issue too
Hi amitchandak
it seems to ask for a gateway, right? What does this mean. Wrong account settings?
Why did it work before June with all measures and now it does not. Sources did not changes since then, updates of the data for measures created before PowerBI July update work fine.
//M
Hi amitchandak ,
It is not the gateway.
If i remove the particular measure of
Sales YEE = CALCULATE( [Sales YTD POS], ENDOFYEAR(DATEADD(data[Date],-1,YEAR),"31.12"))*(1+[Sales growth rate POS])
everything works. Desktop & published, while the gateway is not connected.
So something is in this measure, which causes an error. Interestingly, in the desktop it works fine in all visualizations.
Any ideas?
Thx
//M
Dear all,
got it, it was an measure error. Nothing to do with gateway 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