Forum Discussion

bhanuregonda's avatar
bhanuregonda
Regular Visitor
8 years ago
Solved

Analyze in Excel

  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 - ...
  • bhanuregonda's avatar
    bhanuregonda
    8 years ago

    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.

bhanuregonda's avatar
bhanuregonda
Regular Visitor
8 years ago

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's avatar
bhanuregonda
Regular Visitor
8 years ago

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.