Search found 145 matches

by PhilC
Mon Aug 14, 2017 1:32 pm
Forum: PowerPivot/DAX
Topic: Project Status as of latest date
Replies: 5
Views: 69

Re: Project Status as of latest date

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?
by PhilC
Fri Aug 11, 2017 8:28 am
Forum: General
Topic: Laptop specs [Solved]
Replies: 2
Views: 42

Re: Laptop specs [Solved]

Thanks Matt, appreciate it.
by PhilC
Thu Aug 10, 2017 12:22 pm
Forum: General
Topic: Laptop specs [Solved]
Replies: 2
Views: 42

Laptop specs [Solved]

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
by PhilC
Wed Jul 26, 2017 2:34 pm
Forum: Power Query
Topic: Transform Data
Replies: 2
Views: 143

Re: Transform Data

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...
by PhilC
Wed Jul 12, 2017 10:44 am
Forum: Help with the Book "Learn to Write DAX"
Topic: More Practice questions with answers
Replies: 1
Views: 184

Re: More Practice questions with answers

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...
by PhilC
Tue Jul 11, 2017 7:59 am
Forum: Power Query
Topic: Finding the name of a column in a Power Query
Replies: 9
Views: 1081

Re: Finding the name of a column in a Power Query

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

Cheers
Phil
by PhilC
Fri Jul 07, 2017 9:34 am
Forum: PowerPivot/DAX
Topic: SUMX and ALL
Replies: 4
Views: 305

Re: SUMX and ALL

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 ...
by PhilC
Thu Jul 06, 2017 2:19 pm
Forum: PowerPivot/DAX
Topic: SUMX and ALL
Replies: 4
Views: 305

Re: SUMX and ALL

This might be of use, but need to understand how you arrive at your expected results as this is producing different ones.
by PhilC
Thu Jul 06, 2017 2:12 pm
Forum: PowerPivot/DAX
Topic: SUMX and ALL
Replies: 4
Views: 305

Re: SUMX and ALL

Perhaps you can explain the calc that gets 3.3%. Category Market Growth (Weighted) = Company Sales Weight x Category Market Growth At the Country level = 100% x 3% (your figure) which equals 3%, not 3.3% Also, at the country level, how did you get 3% for Category Market Growth? Current year = 1027, ...
by PhilC
Thu Jul 06, 2017 2:00 pm
Forum: Help with the Book "Learn to Write DAX"
Topic: Use of Filter Excercise 59
Replies: 2
Views: 87

Re: Use of Filter Excercise 59

The exercise asks to find sales of products that have some sales but less than $10k.

The && [Total Sales Amount}>0 is satisfying the "some sale" aspect of this.

Go to advanced search