Append table kpi's

Hi Alex1960ad ,

Let me clarify my earlier comment and provide detailed steps to help you compare 2023 data with 2022 data in your scenario:

1. Calculated Column for Year Comparison:
   In my scenario, I created a calculated column to compare data for 2023 with 2022. This allows you to create year-specific measures or calculations in your model.

2. How to Compare Years in a Single Column (Your Scenario):
   Since your "Year" column contains all years stacked within the same column (e.g., 2500 entries for 2023 followed by 2500 entries for 2022), you can follow these steps in Power BI to achieve the comparison:

   Steps:

   • Step 1: Load both tables into Power BI. Navigate to Transform Data to open Power Query.
   • Step 2: Use Append Queries:
     • If you want to create a new combined table, select Append Queries as New.
     • Alternatively, you can append one table into an existing table.
     • Select both tables to combine them.
   • Step 3: Once the tables are appended, click Close & Apply to load the combined data back into Power BI.

3. Comparing the Data:
   Once your data is appended into a single table, you can create measures in Power BI to compare values for 2023 and 2022. For instance, you can filter the data by year using DAX formulas to compute differences or comparisons between the two years.

I hope this resolves your query! If this solution works for you, kindly click Accept Answer and select Yes for "Was this answer helpful?" Feel free to let me know if you have further questions!