Search results

Hi everyone! I was wondering if there's a way to get ominiture data directly into excel sheet? Currently I am downloading excel sheets and copy/pasting data in excel manually. Is it possible to do data feed/query so that I get data automatically. I was thinking about getting this data into...

Thanks everyone for your input! @Somendra Misra yes what you suggest sounds more safe :) Regards, Z.

You can use power query to get data from various social sites. I have used to mind data from Facebook feeds. Here's an example: https://support.office.com/en-us/article/Connect-to-Facebook-5c3f381b-7268-4fb6-a586-dfb94a03a0aa Hope it helps.

Hi everyone, Hope this message finds you all well :) I am trying to work out how I could password protect powerpivot/data model so that when I send my sheet to clients they won't be able to access the sensitive information in data model. I could encrypt the sheet with password but then it...

Hi Narayan, Thanks for getting back on this. This looks great but there's one issue. When I try to add second series to display 2 different trendlines using the same principle as the above it doesn't work. Thanks for your time. Kind Regards, Z.

Hi everyone, I have encountered the similar problem and this =IF(SomeCondition,NA(),Value) doesn't seem to be fixing the issue. Could it be because I am using excel 2013? Please find the attached file for working example and data set used. Thanks for your time. Kind Regards, Z.

Congratulations! :)

Hi Somendra, Thanks for your time on helping me out :) I've tried that and it works perfectly! Haven't found any issue yet, if so I'll update. I wasn't using filter function properly and your example have help me understand how it works. I do have one more question though, I am trying to...

Hi Somendra, Thanks for getting back on this. These looks good, going to try these and will get back to you soon. Thanks again for your time. Kind Regards, Z.

Hi Somendra, Thanks for following up on this. Please refer the attached file. I have created a new tab named datamodal and highlighted the last 2 column which I want to add into PPT as calc field/columns. Thanks for looking into this. Regards, Z.

Thanks all, I was worried that I have posted it in wrong thread :D @ashish mehra yes, i have been reading about powerpivot but doing it, is more difficult :) If you download the attached file in my PPT post, example output for one issue is in column "O" and others are inside powerpivot. I'll...

Hi Khalid, Thanks for your reply. I have posted PPT related question on "Ask An Excel Question" section but wasn't getting any reply so I though I might have posted it in wrong section. http://chandoo.org/forum/threads/powerpivot-dax-calc-field-column-help.21089/ Wanted to make sure I...

Hi everyone, I am not sure where I should post powerpivot related questions in the forum. Do we have a section for powerpivot only related questions? Thanks, Z.

I have also tried this formula for 7 day moving average calc field but no luck: CALCULATE(SUM(rawdata[Cost]),DATESBETWEEN(rawdata[date],FIRSTDATE(DATEADD(rawdata[date],-6,DAY)),LASTDATE(rawdata[date])))/7

Happy New Year everybody, Hope you all had great fun. I would like to get you advice on few issues I am having with powerpivot DAX please. I am trying to achieve a calculated column which is basically a sumifs in excel language but not sure what I doing wrong. In the attached file I have...

You are awesome! Thanks for your help. Started reading this and very interesting!

Hi bobhc, Thanks for getting back on this. I am looking for regional, particularly for India and Burma. How the pulses rates changes on day by day basis. Thanks again for your time. Kind Regards. Z.

Hi everyone, Hope you all had great fun during the holiday seasons. I have been trying to find pulses data (for past 1-3 year) in daily breakdown format and having trouble where to find this info. Could you guys give me advice/suggestion on where I could get this info please? Thanks for your...

Hi Narayan, Thanks for getting back on this. I am not sure if I follow your suggestion in the last paragraph. Will it be possible for you to provide me an example please? Kind Regards, Z.

Hi Narayan, Would be great if you could get back on this when you have some time. Also tagging @Hui so that he can add his expertise to this. Hi Hui, hope you don't mind tagging you in this conversation. I am struggling to find a solution for this and would be great if you could help me on...

Hi Narayan, Yes, it is quite a big problem. I didn't thought this could turn out to be this complicated. What would you suggest? Am I the only one who's trying to get this into pivot table or has there been any other cases before? Also what would you suggest we should do. Thanks for your...

Hi Narayank, Thanks for help me understand this. I am surprised that excel doesn't have this build in as it's quite straight forward calculation. Will it be possible for you to help me/point me to the right direction for VBA solution please? Kind Regards, Z.

Hi Narayank, Thanks for the solution. Could you help me understand why it is not possible when multiple clients are selected. I want to apply this formula to around 40000 rows of data so I am thinking about pasting these as values once the calculations are done . Sounds like this will cause...

@NARAYANK991 Thanks for taking you time in helping me out. Your solution is perfect as always :) I have added another column "client" and updated the formula you've provided and now the data is incorrect in pivot table. Data is only correct when a particular client is selected, if I select all...

2013