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,
I have appended two tables into one. I need sum of two tables separately. however, the measure is picking up two tables Sum. Can you please help to sum separately. Here is the measure which i have written.
Total HC = TOTALMTD([Total Employees HC],Append1[Reporting Month])
Hi @sureshcu,
If you append table contains the group column, you can add a condition to check the current group column value.
After above step, it will shows the separately sum value.
Regards,
Xiaoxin Sheng
Couple of ideas on this. Depends on how you did your Append though. If you did "Append as New" you could just sum from your original tables. If you did not, then in your original table, create a column called "Source" and just set it equal to "Source1" create the same column "Source" in your other query but set it to "Source2". When you append the tables then you will know which source each row came from, either Source1 or Source2 and then you can use CALCULATE to FILTER your aggregation.
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |