Adding a new table from existing table

[RichOB]

Hi, using the calendar table below, how can I create 2 new individual tables for:

- Start_date_table

- End_date_table

Client	Start_date	End_date
1	01/04/2024	22/04/2024
2	02/06/2024	28/09/2024
3	11/03/2024	11/04/2024
4	14/04/2024	20/09/2024
5	18/05/2025	20/06/2024
6	22/04/2024	21/08/2024

Thanks

[rajendraongole1]

Hi @RichOB - Please find the attached pbix using calculated table or in power query editor you can create as below:

Right-click your CalendarTable and choose Reference (not Duplicate).

For Start_date_table:

Keep only the Client and Start_date columns.

Rename table to Start_date_table.

Do the same for End_date_table, keeping Client and End_date.

Hope this helps.

[burakkaragoz · Accepted solution]

Hi @RichOB ,

You can create those two tables pretty easily using DAX. If you're working in Power BI, just go to the Modeling tab and use "New Table" to define them like this:

Start_date_table = 
SELECTCOLUMNS(
    CalendarTable,
    "Client", CalendarTable[Client],
    "Start_date", CalendarTable[Start_date]
)

End_date_table = 
SELECTCOLUMNS(
    CalendarTable,
    "Client", CalendarTable[Client],
    "End_date", CalendarTable[End_date]
)

This will give you two separate tables — one with just the start dates and one with the end dates, both keeping the Client column for reference.

Let me know if you're trying to do something more specific with these tables.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
translation and formatting supported by AI