Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
96 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |