Forum Discussion

Re: Combining measures into new table

aashton 

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.

 

2 Replies

  • aashton's avatar
    aashton
    Helper V

    The totals are by month, and I have to display them in a matrix by month 2023 - 2024.