Search found 1053 matches

by MattAllington
Sun Jul 07, 2019 9:27 am
Forum: PowerPivot/DAX
Topic: Lost Customers TY vs LY
Replies: 5
Views: 378

Re: Lost Customers TY vs LY

Well it is a non trivial task requiring a non trivial solution. I have copied this code myself and it just worked.
by MattAllington
Tue Jul 02, 2019 5:53 pm
Forum: Help with the Book "Learn to Write DAX"
Topic: Chapter 7, Pg. 68; Pivot Table Results Not Matching
Replies: 3
Views: 1070

Re: Chapter 7, Pg. 68; Pivot Table Results Not Matching

Can you please post your workbook so I can take a look
by MattAllington
Mon Jun 24, 2019 8:51 pm
Forum: Help with the Book "Learn to Write DAX"
Topic: Chapter 7, Pg. 68; Pivot Table Results Not Matching
Replies: 3
Views: 1070

Re: Chapter 7, Pg. 68; Pivot Table Results Not Matching

I realise this is very old, but sorry, I missed it when posted. Do you still have an issue?
by MattAllington
Wed Jun 19, 2019 1:56 pm
Forum: Power Query
Topic: union in advance editor
Replies: 1
Views: 249

Re: union in advance editor

It seems you are trying to use Power Query as a SQL authoring tool. Why not
1. just write a View in SQL and connect to that, or
2. use Power Query to do what you want without writing SQL.
by MattAllington
Sun Jun 16, 2019 9:09 am
Forum: PowerPivot/DAX
Topic: Show only Top 10 AND Bottom 10 (hide everything in middle)
Replies: 1
Views: 282

Re: Show only Top 10 AND Bottom 10 (hide everything in middle)

I guess it is possible.
Write 2x rankx functions to determine the top and bottom items, then use an IF statement to show or hide based on he results.
by MattAllington
Fri Jun 14, 2019 3:24 pm
Forum: Power Query
Topic: Employee Tenure using Power Query or DAX
Replies: 1
Views: 319

Re: Employee Tenure using Power Query or DAX

If you post a realistic sample workbook loaded up in Power Pivot showing what you are after, I will take a look. Just PM me if you post it.
by MattAllington
Fri Jun 14, 2019 3:21 pm
Forum: Power Query
Topic: [Solved] Excel Powerquery: refuse to use invoked functions
Replies: 3
Views: 378

Re: Excel Powerquery: refuse to use invoked functions

You can fix it by changing the privacy settings in Power Query

Data\Get Data\Query Options
Global\Privacy => set to ignore
Current Workbook => set to ignore
by MattAllington
Sun Jun 09, 2019 9:29 am
Forum: PowerPivot/DAX
Topic: userrelationship dates doesn't override
Replies: 2
Views: 350

Re: userrelationship dates doesn't override

My guess is you need to use 2 calculate functions. The outer sets the userelationship and the inner calculates the datesbetween
by MattAllington
Sun Jun 02, 2019 6:58 pm
Forum: PowerPivot/DAX
Topic: Using a Data Model Created in Another Workbook
Replies: 1
Views: 241

Re: Using a Data Model Created in Another Workbook

You can’t export the data-model to another workbook. Just save the workbook with a new name and delete what you don’t want

Go to advanced search

cron