Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Analyze in Excel: Only Measures as Values?

Hey guys,

 

not sure if I don't understand the pivot table in excel enough, but when I click on analyze in excel, only the measures of my PBI Report are available as values.

I want to work with many different fields of my data, is this only possible to work with them as values if I created measures before?

My data looks like

 

ProjectCountryIDInvestorDebtMarginEquity... +80
MilkaGermany01Peter1234125157929237593 
LindtSuisse02

Luke

341343413413413 
ReesesAmerica03Luke14131313441341 
...+200       

 

For example, I want my rows to be Country and my columns to be investor; my values debt.

But I can only use debt if I created a measure =SUM(Debt) before.

Is there a different way than creating measure for every single variable?

Thanks for your help,

Greetings,

 

Janik

Need Help

3 Replies

  • VilleQvist's avatar
    VilleQvist
    Icon for Advocate II rankAdvocate II
    5 years ago

    Yeah, there are some limitations when using analyzing excel, and one of those are that you can't put anything else than measures in values. It is also best practice to use only measures in values so you should just create those. If there are many of columns, you can always use Tabular Editor or similar to create scripts to do those measures all in once.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hey VilleQvist ,

    Thanks for your answer.

    What do you mean with Tabular Editor, how do i do this?