Forum Discussion

Coalsand's avatar
Coalsand
Regular Visitor
3 years ago

New query doesn't bring in calculated columns from source table

Apologies in advance for the super basic question - I'm quite new to PowerBI.

 

I've got an existing table called "00 - Timesheets" consisting of data and calculated fields.

 

I'm trying to create a query which uses that table as a starting point, but the output shows that it's not bringing the calculated fields along with it. How do I ensure that everything is included?

 

My query at this point is

 

let
Source = #"00 - Timesheets"
in
Source

 

and it returns only the following columns:

 

  • 00EntryDate
  • 02 - Team
  • 01 - Employee
  • 10 - Code
  • 11 - Name
  • 13 - Task Name
  • 20 - Total Hrs
  • 14 - Comments
Need Help

1 Reply

  • Coalsand's avatar
    Coalsand
    Regular Visitor
    3 years ago

    Ok, update:

    I see from the list of Queries in Power Query Editor that the query for "00 - Timesheets" yields only the columns I'm getting in my new query output.

     

    To refine my question, is there an easy way to incorporate the queries that produced the calculated columns?