Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I'v defined a calcuated column as below:
ActualWorkTest = AssignmentTimephasedDataSet[Assignment Actual Work]
But that column actually references the Assignment Combined Work column instead. How can that happen?
I've looked at the underlying query but cannot see any issues:
let Source = OData.Feed(#"PWA Site URL" & "/_api/ProjectData/[en-us]"), AssignmentTimephasedDataSet_table = Source{[Name="AssignmentTimephasedDataSet",Signature="table"]}[Data], TableFilter = Table.SelectRows(AssignmentTimephasedDataSet_table, each ([ProjectName] <> "TimesheetAdmin"))), #"Removed Other Columns" = Table.SelectColumns(FremanFilter,{"ProjectId", "AssignmentId", "TimeByDay", "AssignmentActualCost", "AssignmentActualWork", "AssignmentBudgetCost", "AssignmentCombinedWork", "AssignmentCost", "AssignmentRemainingCost", "AssignmentRemainingWork", "AssignmentWork", "ProjectName", "ResourceId", "TaskId", "TaskIsActive", "TaskName"}), #"Renamed Columns" = Table.RenameColumns(#"Removed Other Columns",{{"ProjectId", "Project Id"}, {"AssignmentId", "Assignment Id"}, {"TimeByDay", "Time By Day"}, {"AssignmentActualCost", "Assignment Actual Cost"}, {"AssignmentActualWork", "Assignment Actual Work"}, {"AssignmentBudgetCost", "Assignment Budget Cost"}, {"AssignmentCombinedWork", "Assignment Combined Work"}, {"AssignmentCost", "Assignment Cost"}, {"AssignmentRemainingCost", "Assignment Remaining Cost"}, {"AssignmentRemainingWork", "Assignment Remaining Work"}, {"AssignmentWork", "Assignment Work"}, {"ProjectName", "Project Name"}, {"ResourceId", "Resource Id"}, {"TaskId", "Task Id"}, {"TaskIsActive", "Task Is Active"}, {"TaskName", "Task Name"}}), #"Added Index" = Table.AddIndexColumn(#"Renamed Columns", "Index", 1, 1), #"Renamed Columns1" = Table.RenameColumns(#"Added Index",{{"Index", "RowIndex"}}), #"Reordered Columns" = Table.ReorderColumns(#"Renamed Columns1",{"Project Id", "Project Name", "Assignment Id", "Resource Id", "Task Id", "Task Name", "Task Is Active", "Time By Day", "Assignment Actual Cost", "Assignment Actual Work", "Assignment Budget Cost", "Assignment Combined Work", "Assignment Cost", "Assignment Remaining Cost", "Assignment Remaining Work", "Assignment Work", "RowIndex"}), #"Added Custom" = Table.AddColumn(#"Reordered Columns", "Assignment Start Date", each [Time By Day]), #"Extracted Date" = Table.TransformColumns(#"Added Custom",{{"Assignment Start Date", DateTime.Date, type date}}), #"Reordered Columns1" = Table.ReorderColumns(#"Extracted Date",{"Project Id", "Project Name", "Assignment Id", "Resource Id", "Task Id", "Task Name", "Task Is Active", "Time By Day", "Assignment Start Date", "Assignment Actual Cost", "Assignment Actual Work", "Assignment Budget Cost", "Assignment Combined Work", "Assignment Cost", "Assignment Remaining Cost", "Assignment Remaining Work", "Assignment Work", "RowIndex"}) in #"Reordered Columns1"
Hi@ designertechno
The underlying query is used for processing data sources ,So calculate column won’t be seen in the Edit Queries,
Please share your pbix and some screenshot for us. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.
Best Regards,
Lin
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
123 | |
78 | |
48 | |
38 | |
37 |
User | Count |
---|---|
196 | |
80 | |
70 | |
51 | |
42 |