inconsistent data between desktop and service (calculated table and a measure)

[jondiaphanum]

I have defined a new table ("crecimiento") based on the following DAX expresion:

Crecimiento = SUMMARIZE('contratos';'contratos'[fecha].[Date];' contratos'[nomcontrato];' estructuracomercial'[filial];"CrecDiario";CALCULATE(sum('contratos'[saldoeur]);LASTDATE('contratos'[fecha].[Date])) - CALCULATE(SUM(' contratos'[saldoeur]);PREVIOUSDAY(LASTDATE(' contratos'[fecha].[Date]))))

And I have added a visual with some measures, in example "YTD" as

YTD = TOTALYTD(sum(Crecimiento[CrecDiario]);Crecimiento[Date])

When I see the report in PBI DESKTOP it calculates ok this measure, however, when this I publish to the report server this report, the measure is multiple by much bigger and has nothing to do with the correct result (multiplied by 1MM at least)

Thanks 

[v-cherch-msft]

Hi @jondiaphanum 

It seems it is an issue with timezone.For further,please have a look at this post to check if it could help you.

Regards,

[jondiaphanum]

Thanks for the reponse,

After reading the other post, I decided to change format for "date" value in the following "summarize" dax function

'contratos'[fecha].[Date];

but I am not sure how to change the "grouping" clause in the function so as to change [date] and use convert instead of it