Forum Discussion

VeemalS's avatar
VeemalS
Icon for Helper I rankHelper I
4 years ago
Solved

Power BI for Analyses on Excel

Hello,

 

Is it possible to set measures as Rows on Analysis for Excel just like we have the option on PowerBI to transpose Measures from Columns to Rows?

 

I have the following report to build

 

Thanks

 

Veemal

 

 

Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, VeemalS 

     

    Measure can be displayed as rows in Excel analysis. But it cannot be added directly to Rows. Please refer to the following examples.

    Measure =
DIVIDE (
    ABS ( CALCULATE ( SUM ( 'Table'[Actual] ) - SUM ( 'Table'[Expected] ) ) ),
    CALCULATE ( SUM ( 'Table'[Actual] ) )
)

    Select Analyze in excel in service.

     

    Best Regards,

    Charlotte Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • v-zhangti's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, VeemalS 

     

    Measure can be displayed as rows in Excel analysis. But it cannot be added directly to Rows. Please refer to the following examples.

    Measure =
DIVIDE (
    ABS ( CALCULATE ( SUM ( 'Table'[Actual] ) - SUM ( 'Table'[Expected] ) ) ),
    CALCULATE ( SUM ( 'Table'[Actual] ) )
)

    Select Analyze in excel in service.

     

    Best Regards,

    Charlotte Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.