Recent content by Rajender

Hi All, I am new to Power BI, Can anybody suggest me how to create data model for my specific scenario. I have below mentioned tables :- 1) Resource Plan : it contains details for all resources daily how much hours they have to fill domain wise. 2) Timesheet : it contains the data for all...

Hi Chihiro, Thanks a lot for your valuable support to solve my issue. Its working fine now. Have a nice day to you. Regards, Rajender

Hi Chihiro, Still the output is not correct , if there is no Zero in the row, its still showing output as last header row. In my last attachment uploaded here , I have updated the correct output file. Please assist. Regards, Rajender

Hi Chihiro, Thanks for your help. I have checked the given formula , but its not showing the correct Header output. I have shown the correct output in column DX in attached file. Please suggest , where I need to do modification.

Hi Chihiro, I found one formula nearest to my requirement could you help me out , what modification I need to require here :- Here its giving me the output and capture header of last non-zero cell. but I need here column header next to last non zero cell. =LOOKUP(2,1/(R2:CW2<>0),$R$1:$CW$1) I...

Hi Chihiro, Well noted your comments, but actually this template is very old created by someone else and around 35 macros are taking references only from this template only. its very difficult for me to change the existing macros. because I have only knowledge of basic VBA macro of recording...

Hi All, I have a Master Table Worksheet. I want to print message in Column DX "to be check" if below mentioned conditions matches. 1) RESOURCE STATUS = Should be ENGAGED/APPROVED. 2) ASSIGNMENT STATUS = Should be Blank 3) Now check for month from cell CW to R any value written as zero but the...

Hi Nebu, I am getting file size is huge error here. I have uploaded all the file in below given link. http://1drv.ms/1GJqWNc Regards, Rajender

Hi All, I have 1 master sheet in which I need to apply vlookup function in multiple sheets and from 3 different files(All files are located in same folder). Below are the headings for which I am applying vlookup function :- 3G 'TRANS_TYPEIP to IP Swap StatusIntervention DateIP to IP commentIP...

Hi All, I have raw data in below format around 20K to 30K rows and I need to rearrange the rows based on below mentioned condition :- 1) I need to filter on Ring name for example I filter Ring A05. 2) Then I filter 1 by 1 to ATN loop back column for example : I filter 10.35.201.1. 3)...

Hi All, I have worksheet where I have a below 2 main sheets :- 1) Code list : having example list of 1 codes which is required to copy for all the different IP's 2) IP list : for different criteria. currently I am taking example of 2 example :- 1) MW : First I go to code list and there in...

Hi All, I have found the below mentioned code by google to copy the files from a particular location to another :- But its showing error while I am changing the Frompath: to "https://abc.internal.abc.com/sites/Documents/N4S>" that path does not exists. Also when I am running same code in local...

Hi Narayan, Sorry my mistake. you are correct misstype wrong reference. could you please assist for the same. I tried with recording macro but not successful because every time Main data sheet volumn of all the data with not same. In current file all data is of approx 11000 rows but it can be...

Hi All, I have to return value in comma seperated(or "-" sign) in sheet 1 from range D3 :E last row. Criteria mentioned in G1 and I1. Example : In sheet 1 Header name 3G , and cell B3 which is 30537C1 in current case I will go to "All data" sheet column G and filter with same code :30537C1 and...

Hi Srinidhi, For the time being I am adding the line chart by calculated item field. If is there any other workaround or chart type option. Thanks in advance for your valuable suggestions. Regards, Rajender