Forum Discussion
Dax help
Dear All,
we have two different databases to pick date values from SharePoint to another database.
i am attaching two different databases in excel format for your understanding.
Query
in sql database excel we have 16 PP table in that table i need date from SharePoint file table (actual finish date)
SQL database data
Sharepoint data file
| output file | |||
| Count | Count | ||
| Project name | Tower | RCC level | PP current level |
| c1 | TowerE | 33 | 26 |
3 Replies
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
https://docs.google.com/spreadsheets/d/1A5VUAEUEe5JWno-3d12_UZI_-rdvmXXC/edit#gid=1884533589
https://docs.google.com/spreadsheets/d/1B0iHHAuMWlASblfDewC3x_ysP-9KRwUd/edit#gid=965455767
we have provided access to the file both are different file
we have need the actual finish date column data in 16 pp column.
