Forum Discussion
Adding a new table from existing table
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
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
2 Replies
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.
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
