PowerPivot Forum

Thanks Matt, will do some testing when more data comes through during the week. At least it is not isolated to me.

Hi, I have a query with a column formatted as Date, when the data is refreshed and loaded to Table in an Excel sheet, new rows are not formatted as a date, they have the number appearance eg 43209. We are using this data as a source for Tableau, so need to be properly formatted as Tableau is not pic...

The code for the Variable measure does not align with the code for the 2 measure approach, using different tables and fields (see Date comparison at end of second measure).

Could this be the reason?

Thanks Matt, appreciate it.

Hi Matt,

Do you have an opinion on what specs are needed for a laptop to use for developing Power BI / Power Pivot models?

Can you share what machine you are using or lusting after to use?

Cheers
Phil

Hi, the attached might put you in the right direction. 1. Add an Index Column 2. Add columns for Count, List, Units that will become your column headings, concatenating "Count", "List", "Units" to the [Index] 3. Select each new column in turn (not together) and Pivot th...

Great work getting through the book and wanting to learn more. There are a host of sources of DAX / Power Pivot / Power BI online, Google will help you locate them. One such site is SQLBI, it has a site DAX Patterns section that provides DAX measures to solve real needs. Check it out at http://www.d...

Just wanted to say this solution keeps on giving, thanks very much.

Cheers
Phil

Hi, What you are after is one calculation on the Category rows and another on the Country subtotals, is that correct? On the Category rows you want [Company Sales Weight] x [Category Market Growth] and on the Country row you want the SUM of the value in the Category rows. This required is beyond my ...

This might be of use, but need to understand how you arrive at your expected results as this is producing different ones.