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,
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 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
Hi All,
I have data sheet where I have following columns starting from Cell A1 to P1
Work Order_WO000 Dummy Project (PC)WO000 Type_WO000 Dummy LLC Upload DateUS000 Node 2GWO600 2G Line Swap/LL Avoided StatusWO600 2G Line Swap/LL Avoided ActualWO600 2G Line Swap/LL Avoided Upload DateUS000 Node...
Hi Srinidhi,
Thanks for your help. But unable to find the solution.
IF any other way to show stacked chart with target line ?
Or any VBA macro can provide the solution ?
I tried via recording macro but not successful.
Regards,
Rajender
Hi Narayank,
I check once again the given link and found how its created. But in my case I need it should be dynamicaly updated which is equal to counta of column A and when I am trying the above formula its not working "=counta([ 'Work Order'])"
Hi Narayank,
I check but unable to clear how its made. Also check in google about steps to follow. I need a straight line in my current chart which needs to be equal of count of column A. and needs to be dynamically updated.
I also tried formula in calculated item "=counta([ 'Work Order'])"...
Hi All,
I have 2 sheets :-
1) Sheet name "Final Sheet" : Raw data which is coming after running some calculation after a vba macro.(currently not attached other sheets). raw dump will always changes as soon as I will run macro a macro.
2) Sheet 2 name "Pivot" : this sheet contains the pivot...
Hi All,
I learned a lot from this site and I applied many things useful tracker in my current work roll which is very much appreciated by my superiors.
I am Thankful to all of you.
Now I want to share I issue about excel. I always see the syntax wherever I am applying any formula. yesterday...