Search found 1050 matches

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: 1
Views: 386

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

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

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

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

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

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

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
by MattAllington
Wed May 29, 2019 8:06 pm
Forum: Help with the Book "Supercharge Power BI"
Topic: Database load fails
Replies: 1
Views: 132

Re: Database load fails

Sorry, I missed this before. Have you resolved the issue? You have 2 choices. You can read my article here, or you can try to load the data from the excel file provided in the download.

https://exceleratorbi.com.au/64-bit-pow ... ce-can-do/

Go to advanced search