User Profile
sameergupta60
Helper IV
Joined 7 years ago
User Widgets
Contributions
Dax help
Dear Team, attached screenshot showing data with serial no, when we apply sort to the not awarded column serial no gets changed but I need the serial no from 1 instead of the sort column. Sample data attached My query needs the serial no along with the sort condition not awarded packages come to first & awarded after that with continue Sr No2 Contract Award Package Critical / Non Critical Dwg status (Provided/ Not provided) BOQ Status(Provided/ Not Provided) Awarded / Not Awarded 3 Balcony, Common Area & External Lights Critical Provided Provided Not Awarded 10 Energy Meter Non Critical Provided Provided Not Awarded 5 FTTH Non Critical Provided Provided Not Awarded 4 Home Automation Non Critical Provided Provided Not Awarded 29 Inverter (UPS) - Free Issue Material Non Critical Provided Provided Not Awarded 6 Video Door Phone Non Critical Provided Provided Not Awarded 47 A1 & A4 Plumbing Critical Provided Provided Awarded 49 Aluminium Shuttering - T1 Critical Provided Provided Awarded 50 Aluminium Shuttering - T4 Critical Provided Provided Awarded 28 Cables, Mains anad Sub mains Critical Provided Provided Awarded 45 CP sanitaryware Fixing - Free Issue Material Non Critical Provided Provided Awarded 15 CTFA Non Critical Provided Provided Awarded 11 DG - Fress Issue Material Non Critical Provided Provided Awarded 12 DG Works - Low Side Non Critical Provided Provided Awarded 38 Door Frame - Free Issue Material Non Critical Provided Provided Awarded 32 Electrical Switches & Other Fixture Fixing - Free Issue Material Non Critical Provided Provided Awarded 1 Electrical Works Critical Provided Provided Awarded 21 External Painting Critical Provided Provided Awarded 23 Façade - Aluminium Doors & Windows Critical Provided Provided Awarded 20 False Ceiling Non Critical Provided Provided Awarded 44 Finishing vendor Critical Provided Provided Awarded 43 Finishing vendor- A1, EWS Critical Provided Provided Awarded 7 Fire Alarm & PA Critical Provided Provided Awarded 35 Fire Door - Free Issue Material Critical Provided Provided Awarded 18 Fire Fighting - Free Issue Material Critical Provided Provided Awarded 19 Fire Fighting Works Critical Provided Provided Awarded 2 Hardscape Non Critical Provided Provided Awarded 36 Internal Door Shutter - Free Issue Material Critical Provided Provided Awarded 22 Internal Painting Critical Provided Provided Awarded 31 Internal Wiring & DB, ONT Box - Free Issue Material Non Critical Provided Provided Awarded 48 Internal/External Plumbing Works Critical Provided Provided Awarded 46 Internal/External Plumbing works - Free Issue Material Non Critical Provided Provided Awarded 39 Joinery Work Non Critical Provided Provided Awarded 24 Lift Installation Critical Provided Provided Awarded 25 Light fixtures in common areas & in landscape - Free Issue Material Non Critical Provided Provided Awarded 26 LT Panel Critical Provided Provided Awarded 27 LV systems (TV & Telephone Wiring) - Vendor & Free Issue Material Non Critical Provided Provided Awarded 37 Main Door Shutter - Free Issue Material Critical Provided Provided Awarded 30 Rising Main - Vendor & Free Issue Material Critical Provided Provided Awarded 8 Security systems - Boom Barrier & CCTV Non Critical Provided Provided Awarded 1 Softscape Non Critical Provided Provided Awarded 9 Solar System Non Critical Provided Provided Awarded 41 Stone - Free Issue Material Non Critical Provided Provided Awarded 14 STP - Mechanical Works Critical Provided Provided Awarded 42 Tiles - Free Issue Material Non Critical Provided Provided Awarded 16 Ventillation - Free Issue Material Critical Provided Provided Awarded 17 Ventillation Works Critical Provided Provided Awarded 40 Wooden Flooring Non Critical Provided Provided Awarded 13 WTP - Mechanical Works Critical Provided Provided AwardedRe: Dax help
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 R27Dax help
Dear All, we need help on the below dax. ActualFinish = CALCULATE ( FIRSTNONBLANK( C1[ActualFinish], 1 ), FILTER(ALL(C1),C1[UniqueTaskID]=OPSCollection[ASTA Unique ID]) ) using the above dax got the data for some rows but in some rows date not showing. attached screenshot for your reference. Opscollection Table screenshot C1 Table screenshot Actual finish date from c1 need on opscollection table actual finish columnRe: Dax help
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.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 https://docs.google.com/spreadsheets/d/1B0iHHAuMWlASblfDewC3x_ysP-9KRwUd/edit?usp=drive_link&ouid=111006166140480215388&rtpof=true&sd=true Sharepoint data file https://docs.google.com/spreadsheets/d/1A5VUAEUEe5JWno-3d12_UZI_-rdvmXXC/edit?usp=drive_link&ouid=111006166140480215388&rtpof=true&sd=true output file Count Count Project name Tower RCC level PP current level c1 TowerE 33 26HELP on below query
Dear Team, we need help on the below query attached screenshot. data table in the screenshot we have levels, and the current RCC date if my RCC at 10 then the next column shows RCC date. FL is not started if blank idle days are the calculation of Rcc at datediff(10-floor date, today, day) Output needs in an attached screenshot
