Forum Discussion
Analyze in Excel
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.
Hi bhanuregonda,
Could you please send or show us the sample data where you have your difference.
We will try to figure out.
Ninter
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")))
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
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.