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.
Hi,
Looking to summarize a union of 2 tables by Machine 3 and assigned date here is my union code:
OEE_TRANSIT = UNION ( SELECTCOLUMNS ( t_Batch, "Machine #", t_Batch[c_MachineId], "Assigned date", t_Batch[ASSIGNED_DATE], "RUN_HOURS", t_Batch[RUN_HR_DAY1], "SET_HOURS", t_Batch[SET_HR_DAY1], "BATCH_HOURS", t_Batch[BATCH_HR_DAY1] ), SELECTCOLUMNS ( FILTER ( t_Batch, t_Batch[DAY_1] <> t_Batch[DAY_2] ), "Machine #", t_Batch[c_MachineId], "Assigned date", t_Batch[DAY_2], "RUN_HOURS", t_Batch[RUN_HR_DAY2], "SET_HOURS", t_Batch[SET_HR_DAY2], "BATCH_HOURS", t_Batch[BATCH_HR_DAY2] ) )
I get this error when i try to summarize it:
thanks for the help
Solved! Go to Solution.
Looks like it wants you to have an aggregation for
t_Batch[BATCH_HR_DAY1]
like SUM(t_batch[BATCH_HR_DAY1]) ?
Looks like it wants you to have an aggregation for
t_Batch[BATCH_HR_DAY1]
like SUM(t_batch[BATCH_HR_DAY1]) ?
thank you @Greg_Deckler, It worked! is there a way to do this in "1 step" instead of having a middle table as Im using??
Depending on your data source, you could write a SQL union statement or use an Append/Merge query perhaps.
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 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |