Search found 147 matches

by PhilC
Wed Oct 03, 2018 10:49 am
Forum: Power Query
Topic: New rows in table not formatted as Date
Replies: 2
Views: 158

Re: New rows in table not formatted as Date

Thanks Matt, will do some testing when more data comes through during the week. At least it is not isolated to me.
by PhilC
Tue Oct 02, 2018 10:51 pm
Forum: Power Query
Topic: New rows in table not formatted as Date
Replies: 2
Views: 158

New rows in table not formatted as Date

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...
by PhilC
Mon Aug 14, 2017 1:32 pm
Forum: PowerPivot/DAX
Topic: Project Status as of latest date
Replies: 5
Views: 2331

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: 4
Views: 4319

Re: Laptop specs [Solved]

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

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: 2108

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: 2
Views: 2549

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: 5253

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: 2566

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: 2566

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.

Go to advanced search

cron