Forum Discussion
Creating new table with Calculated Columns
In response to VahidDM, here's my question with more details in text format. Thank you!
I have a table below:
Table A
Project Name Type Identifier Finish Date
Project A Large RK-1 2022-01-01
Project A Large RK-2 2022-01-31
Project A Large RK-3 2022-03-15
Project A Large RK-4 2022-03-28
Project B Med RK-5 2020-08-01
Project B Med RK-2 2020-09-01
Project B Med RK-6 2020-12-31
Project B Med RK-4 2021-01-15
Project C Small RK-2 2021-08-06
Project C Small RK-3 2021-09-07
Project C Small RK-7 2021-10-11
I would like to create a new table that will look like this:
Table B
Project Name Type Deliverable Duration
Project A Large XX datediff(finish date of RK-1 and finish date of RK-2
Project A Large YY datediff(finish date of RK-3 and finish date of RK-4
Project B Med XX datediff(finish date of RK-5 and finish date of RK-2
Project B Med YY datediff(finish date of RK-6 and finish date of RK-4
Project C Small XX datediff(finish date of RK-2 and finish date of RK-3
Project C Small YY datediff(finish date of RK-3 and finish date of RK-8
I have created separate DAX tables for each deliverable and combined all those dax tables together. But is there a way where I can combine all of these in one table at once without creating multiple tables?
Thank you in advanced for your help.