Analyze in Excel

[bhanuregonda]

Hi,

I have a powerbi report in which I have YTD calculated measure and I am getting the correct result in power BI for the %YTD value out of it, but when I am analyzing that report in Excel - I am not getting the same values as in Power bi in that column. Not sure why is it different from power bi to analyze excel.

Please help me with this.

Thanks

[Interkoubess]

Hi @bhanuregonda,

Could you please send or show us the sample data where you have your difference.

We will try to figure out.

Ninter

[bhanuregonda]

Not sure how can I share the data as it is huge. Basically, we have YTD calculated on fields and calculating %Revenue out of this YTD with the following expression in power bi which is getting perfect results in BI but the same calculation values are wrong when i analyze it in Excel.

%Dummy = calculate(divide([MthActual],calculate(sum(FactTable[Amount]), ALLEXCEPT('FactTable', FactTable[CompanyName],CalendarDay[Date].[Year],CalendarDay[Date].[Month]),'FactTable'[TopLevelSegmentName]="Total Revenue"))) 

[bhanuregonda · Accepted solution]

I have resolved this issue by removing Calendar dimension's Month and Year and replaced them with Dates which i have in FactTable dimension itself. Not sure why the month and year are causing an issue in excel but not in power bi.

Thanks all for looking into this.

[Interkoubess]

Hi @bhanuregonda,

You can share a link ( or a pbix file if it does not contain sensitive information ) on dropbox or other shared tools in order to look deeper in your request.

Otherwise I cannot figure out or  other members will reply.

Ninter