Adding a new table from existing table

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