Forum Discussion
jdbuchanan71
2 years agoSuper User
Re: Combining measures into new table
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.