Forum Discussion

lea_313's avatar
lea_313
Icon for Helper I rankHelper I
4 years ago

Calculated subtable

Hi   I need to analyse some data and get a specific output I am struggeling with:   Raw Data     Company Revenue Owner Client A 1000 Geoff Client B 1500 Bob Client C 2000 ...
Need Help
lea_313's avatar
lea_313
Icon for Helper I rankHelper I
4 years ago

 

When i replace 'data table' with my table name and then the column in [ ], it just shows various errors

 

I only have a company ID in this data set. This then links to a company master list that would show their company name.

Thanks for the quick help really greateful

grantsamborn's avatar
grantsamborn
Icon for Solution Sage rankSolution Sage
4 years ago

Those calculated columns are in DAX not PowerQuery.

 

Sorry if I wasn't clear.

  • lea_313's avatar
    lea_313
    Icon for Helper I rankHelper I
    4 years ago

    ok great thanks

     

    Will have a look and see how it works, thanks again