Forum Discussion
Combining measures into new table
Hello,
I have five tables, that each have a measure which distinct counts a field in that table. For example, Total Applicants = DISTINCTCOUNT(Applications[Candidate ID)). These tables only have 2024 data. I don't have 2023 data, I only have the 2023 values, so I created a new table and input these. For example, Date, Measure Value ...06/01/23 Total Applicants 100. I need to display the 2023 and 2024 together in a matrix, so I've been trying to create a table that unions the 2024 and 2023 measures. However, the 2024 values in the new table do no match up with what the actual values are. I've tried using ADDCOLUMNS, SELECTCOLUMNS, SUMMARIZE, and keep getting the wrong values.
For example,
Rather than adding the 2024 values to a summary table, I would suggest adding the amounts from your old summary table to your current measure, something like this:
Total Applicants = DISTINCTCOUNT ( Applications[Candidate ID] ) + SUM ( '2023 table name'[Application Count Field] )As long as your Calendar table is linked correctly to both tables, it should work.
4 Replies
Rather than adding the 2024 values to a summary table, I would suggest adding the amounts from your old summary table to your current measure, something like this:
Total Applicants = DISTINCTCOUNT ( Applications[Candidate ID] ) + SUM ( '2023 table name'[Application Count Field] )As long as your Calendar table is linked correctly to both tables, it should work.
ok, Add a date field to your old summary table that is the first day of the month then you can link that to your calendar table and show all the amounts by month.
