Search results

Hello, Am looking for a formula which gives me no.of weeks in a month i.e. week1, week2, week3,week4 & week5 based on date likewise for full year. Ex: I have a data for full year that contains no.of tickets processed on each workday. Based on date i.e. 1-Jan-13, i want to contruct a formula...

Hi Chandoo, I'm looking for two formula as per my requirement given below: 1. From datetime format (1/1/2013 12:51:13 AM) - how to extract only time into a separate cell? 2. Our shift start at 6AM & ends at 2AM. Ex: If i start my shift on Monday morning at 6AM it goes upto 2AM on Tuesday...

Hi, My question after observation is that "why grand totals are not selected/coming in powerpivot charts"? Is there a way where we can see that grand totals also appear in stacked chart. Please help!! Thanks, Vamshe

Hi, Am looking for a similar formula like sumif which will add/concatenate text data from one sheet to another. See the example below: Source file data- Name Travelled Region A USA B APA C EU B USA C APA B EU Name Region A =(formula) i.e. USA B =(formula) i.e. APA/USA/EU C...

Hi, Could you please provide me a DAX formula (powerpivot/measure) wherein i can calculate no.of workings days excluding saturdays, Sundays & Holidays based on two different regions. Thanks in advance. Regards, Vamshe

HI Hui, I have attached sample file for your easy understanding and the link is below. Regards, Vamshe

Hi Chandoo, I need your help in solving my problem which am facing & trying from past one week to find a solution. About the problem: I have a employee database which consists of Managers, Executives,Permanent & Temporary etc. Same data i have kept in pivot table which has given me the...