Dax help

[sameergupta60]

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 

https://docs.google.com/spreadsheets/d/1B0iHHAuMWlASblfDewC3x_ysP-9KRwUd/edit?usp=drive_link&ouid=11...

Sharepoint data file

https://docs.google.com/spreadsheets/d/1A5VUAEUEe5JWno-3d12_UZI_-rdvmXXC/edit?usp=drive_link&ouid=11...

output file
		Count	Count
Project name	Tower	RCC  level	PP current level
c1	TowerE	33	26

[sameergupta60]

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.

[foodd]

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-...

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.

[sameergupta60]

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