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 - 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

  • 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.

4 Replies

  • Interkoubess's avatar
    Interkoubess
    Solution Sage
    8 years ago

    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'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"))) 

      • Interkoubess's avatar
        Interkoubess
        Solution Sage
        8 years ago

        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