I have this table I would like to create measurement get the last traded value for each day. E.g. How the DAX query should look like?

I use Excel 2013 and Power View and SQL Server 2008 R2. After create my Data Source and my chart in Excel When I want save my Excel file I get this message be careful parts of your document may i...

What is the difference between powerpivot, powerquery and powerbi? What are the use cases for each tool? What are the limitations? What requirements must be met to use the tool?

We have 4GB csv file which is the source for power query in an Excel document. It takes some time to set up all of the transformations, and we would like to be able to reuse the steps when creating...

I received a workbook which contains two tables in power-pivot (one around one million rows, another 20 mill rows). I would like to rip this out (as anything really - but let's say a CSV) so that I...

I have a OLAP Data Model that is published on the Power-BI Services. I built a report using CUBE formulas. I need to do a bit of Hiding and Showing Columns based on the CUBEVALUE results. And I nee...

Excel 2016 (16.0.6965.2076) SQL Server 2014 (12.0.4213.0) I have an SSRS report with 10 parameters - two are dates and the other 8 are text dropdowns using a query to populate the options. If I t...

Actually, I would be satisfied just getting to pick the direction of the one-to-many. I have one table, the result of a SQL query that I want to use as a lookup table. It is unique in its key colum...

Imagine I have a quality control in a factory retrieving the state of each product StateId 1 - Good 2 - Acceptable 3 - Subproduct 4 - waste My table 'StateIdHistory' gives me the state of each Pro...

Disclaimer: This question was posted in msdn forum but since I didn't get any reply (surprisingly), I am cross posting it here as well. You might want to check that link before you try to attempt t...

I have no experience at all with QlikView, but I have read great reviews about it. According to Gartner Research Report 2012, QlikView is in the top quadrant together with Microsoft, Oracle, SAP an...

What seemed like a trivial task turned into a real nightmare when I had to read in some data from a PowerPivot model using Python. I believe I've researched this very well over the last couple of d...

One of my client has made this incredible (and really huge) Excel document with many data sources, sheets, Powerpivot tables, graphs, etc... Awesome work. He want to share it with authorized peopl...

I have data in powerpivot that I've modified and I'd like to place it into the workbook as a regular table (and not as a pivottable). I need this so that I can run use the table for some vlookups f...

I know that Excel 2010 Slicers will visually indicate when there is no data associated with a particular slicer selection. For example, they are faded in color for 2010 if you have no values in 201...

I've got a BI Dashboard in Excel 2010 using Powerpivot, which is connected to a number queried tables on one SQL Server. When the connections were setup, I checked the box to 'save password' on eac...

I am building a data model within Power Pivot for Excel 2013 and need to be able to identify the max value within a column for a particular group. Unfortunately what I thought would work and what I...

I was able to connect to the powerpivot datamodel with amo: string ConnString = "Provider=MSOLAP;Data Source=$Embedded$; Locale Identifier=1033;Location=" + ThisAddIn.Current.Application. Acti...

This article Connecting to PowerPivot with C# is the closest to my question but it seems that it is out of date. I attempted the methods they showed in the answer but the example ThisWorkbook.Con...

I have created a power pivot table as shown in the picture. I want to calculate quarter over quarter sales change. For which I have to divide for example corporate family "Acer" 's sales in 2012Q4 ...

I am searching for a method to utilize within Microsoft PowerPivot 2010 that will allow me to perform dynamic ranking that will automatically update the associated rank value based on filters and s...

Does anyone know if MVC 4 WebApi can (or will) be consumable in power-pivot?

I have a MySQL DB on hostmonster.com and I am trying import data in excel powerpivot, but having hard time connecting to it. Does anyone know if Excel powerpivot can even connect to MySQL? Error ...

Is it possible to connect to a PowerPivot model in an Excel .xlsx file? (Not hosted on a SharePoint site... just the local file). It must be, since Tableau can do it. Anyone have any clues?