Forum Discussion
Dax help
Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot). Please rephrase your questions for clarity so the reader may understand your ask.
The sharing permission of the Shared files is not set correctly, and results in the following error:
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.
Hi Team,
Sorry for late reply.
we have two different Table
1 :- L1
2 :- South-pour
we need date new column in L1 that
there are multiple levels in l1 code82 we need single date in G00 , R01 , R02 etc from below table south-pour G00 , R01,R02 etc Actual finish date.
please suggest for Dax
L1 table
| ProjectName | Code33 | Code82 | 01 RCC | 16 PP |
| Bagaluru | Tower E | B01 | ||
| Bagaluru | Tower E | B02 | ||
| Bagaluru | Tower E | B02 | 04-02-22 09:36 | |
| Bagaluru | Tower E | B03 | ||
| Bagaluru | Tower E | B03 | 28-02-22 17:00 | |
| Bagaluru | Tower E | F00 | 29-12-21 17:00 | |
| Bagaluru | Tower E | G00 | ||
| Bagaluru | Tower E | G00 | 09-04-22 17:00 | |
| Bagaluru | Tower E | R01 | ||
| Bagaluru | Tower E | R01 | 20-05-22 08:00 | |
| Bagaluru | Tower E | R02 | ||
| Bagaluru | Tower E | R02 | 15-06-22 17:00 | |
| Bagaluru | Tower E | R03 | ||
| Bagaluru | Tower E | R03 | 26-06-22 17:00 | |
| Bagaluru | Tower E | R04 | ||
| Bagaluru | Tower E | R04 | 08-07-22 17:00 | |
| Bagaluru | Tower E | R05 | ||
| Bagaluru | Tower E | R05 | 18-07-22 17:00 | |
| Bagaluru | Tower E | R06 | ||
| Bagaluru | Tower E | R06 | 05-08-22 17:00 | |
| Bagaluru | Tower E | R07 | ||
| Bagaluru | Tower E | R07 | 14-08-22 17:00 | |
| Bagaluru | Tower E | R08 | ||
| Bagaluru | Tower E | R08 | 25-08-22 17:00 | |
| Bagaluru | Tower E | R09 | ||
| Bagaluru | Tower E | R09 | 08-09-22 17:00 | |
| Bagaluru | Tower E | R10 | ||
| Bagaluru | Tower E | R10 | 17-09-22 17:00 | |
| Bagaluru | Tower E | R11 | ||
| Bagaluru | Tower E | R11 | 22-09-22 17:00 | |
| Bagaluru | Tower E | R12 | ||
| Bagaluru | Tower E | R12 | 08-10-22 17:00 | |
| Bagaluru | Tower E | R13 | ||
| Bagaluru | Tower E | R13 | 19-10-22 17:00 | |
| Bagaluru | Tower E | R14 | ||
| Bagaluru | Tower E | R14 | 30-10-22 17:00 | |
| Bagaluru | Tower E | R15 | ||
| Bagaluru | Tower E | R15 | 13-11-22 17:00 | |
| Bagaluru | Tower E | R16 | ||
| Bagaluru | Tower E | R16 | 26-11-22 17:00 | |
| Bagaluru | Tower E | R17 | ||
| Bagaluru | Tower E | R17 | 04-12-22 17:00 | |
| Bagaluru | Tower E | R18 | ||
| Bagaluru | Tower E | R18 | 16-12-22 17:00 | |
| Bagaluru | Tower E | R19 | ||
| Bagaluru | Tower E | R19 | 24-12-22 17:00 | |
| Bagaluru | Tower E | R20 | ||
| Bagaluru | Tower E | R20 | 14-01-23 17:00 | |
| Bagaluru | Tower E | R21 | ||
| Bagaluru | Tower E | R21 | 28-01-23 17:00 | |
| Bagaluru | Tower E | R22 | ||
| Bagaluru | Tower E | R22 | 11-02-23 17:00 | |
| Bagaluru | Tower E | R23 | ||
| Bagaluru | Tower E | R23 | 23-02-23 17:00 | |
| Bagaluru | Tower E | R24 | ||
| Bagaluru | Tower E | R24 | 15-03-23 17:00 | |
| Bagaluru | Tower E | R25 | ||
| Bagaluru | Tower E | R25 | 31-03-23 17:00 | |
| Bagaluru | Tower E | R26 | ||
| Bagaluru | Tower E | R26 | 09-04-23 17:00 | |
| Bagaluru | Tower E | R27 | ||
| Bagaluru | Tower E | R27 | 19-04-23 17:00 | |
| Bagaluru | Tower E | R28 | ||
| Bagaluru | Tower E | R28 | 30-04-23 17:00 | |
| Bagaluru | Tower E | T01 | 21-05-23 17:00 |
South-pour table
| Project Name | Tower | Level | Actual finish date |
| Bagaluru | Tower G | G00 | 07-09-22 00:00 |
| Bagaluru | Tower G | R01 | 29-09-22 00:00 |
| Bagaluru | Tower E | R02 | 25-08-22 00:00 |
| Bagaluru | Tower G | R02 | 17-10-22 00:00 |
| Bagaluru | Tower E | R03 | 08-09-22 00:00 |
| Bagaluru | Tower G | R03 | 08-11-22 00:00 |
| Bagaluru | Tower E | R04 | 25-09-22 00:00 |
| Bagaluru | Tower G | R04 | 11-11-22 00:00 |
| Bagaluru | Tower E | R05 | 15-10-22 00:00 |
| Bagaluru | Tower G | R05 | 28-11-22 00:00 |
| Bagaluru | Tower E | R06 | 27-10-22 00:00 |
| Bagaluru | Tower G | R06 | 15-12-22 00:00 |
| Bagaluru | Tower E | R07 | 05-11-22 00:00 |
| Bagaluru | Tower G | R07 | 02-01-23 00:00 |
| Bagaluru | Tower E | R08 | 21-11-22 00:00 |
| Bagaluru | Tower G | R08 | 07-01-23 00:00 |
| Bagaluru | Tower E | R09 | 29-12-22 00:00 |
| Bagaluru | Tower E | R10 | 01-01-23 00:00 |
| Bagaluru | Tower E | R11 | 11-01-23 00:00 |
| Bagaluru | Tower E | R12 | 22-01-23 00:00 |
| Bagaluru | Tower E | R13 | 01-02-23 00:00 |
| Bagaluru | Tower E | R14 | 08-02-23 00:00 |
| Bagaluru | Tower E | R15 | 21-02-23 00:00 |
| Bagaluru | Tower E | R16 | 09-03-23 00:00 |
| Bagaluru | Tower E | R17 | 26-03-23 00:00 |
| Bagaluru | Tower E | R18 | 12-04-23 00:00 |
| Bagaluru | Tower E | R19 | 28-04-23 00:00 |
| Bagaluru | Tower F | R19 | 21-06-23 00:00 |
| Bagaluru | Tower E | R20 | 13-05-23 00:00 |
| Bagaluru | Tower F | R20 | 25-06-23 00:00 |
| Bagaluru | Tower E | R21 | 28-05-23 00:00 |
| Bagaluru | Tower F | R21 | 30-06-23 00:00 |
| Bagaluru | Tower F | R22 | 04-07-23 00:00 |
| Bagaluru | Tower F | R23 | |
| Bagaluru | Tower F | R24 | |
| Bagaluru | Tower F | R25 | |
| Bagaluru | Tower F | R26 | |
| Bagaluru | Tower F | R27 |