Forum Discussion
Solved
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 2...
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.
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.
Thank you, that worked!