Recent content by mrzoogle

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...