Search found 985 matches

by MattAllington
Tue Jul 31, 2018 3:22 pm
Forum: Power Query
Topic: Pulling Data from Stacked Column with No Pattern
Replies: 4
Views: 715

Re: Pulling Data from Stacked Column with No Pattern

OK, here is my YouTube session that explains how I solved this problem. https://www.youtube.com/watch?v=KrJH4elS9eM
by MattAllington
Tue Jul 31, 2018 10:03 am
Forum: PowerPivot/DAX
Topic: Many to Many filter table problem [Solved]
Replies: 9
Views: 1240

Re: Many to Many filter table problem [Solved]

The yellow warning message in Excel is likely a false warning. Unfortunately it cannot be turned off. The principle of expanded tables means the following. Place a filter on table A (eg a slicer or place a column in a row in a visual). Write a measure for Table B as follows (place it in table B) mea...
by MattAllington
Tue Jul 31, 2018 7:34 am
Forum: Power Query
Topic: Number format when using "From a File" Import
Replies: 4
Views: 596

Re: Number format when using "From a File" Import

Can you post some sample data?
by MattAllington
Tue Jul 31, 2018 7:32 am
Forum: Power Query
Topic: Pulling Data from Stacked Column with No Pattern
Replies: 4
Views: 715

Re: Pulling Data from Stacked Column with No Pattern

FYI, I created a video showing how to do this yesterday. I hope to share it today.
by MattAllington
Fri Jul 27, 2018 12:21 am
Forum: PowerPivot/DAX
Topic: Many to Many filter table problem [Solved]
Replies: 9
Views: 1240

Re: Many to Many filter table problem [Solved]

You can’t use that formula as a measure - it is a table formula and won’t work the way you have applied it. You can read my article here for more information. https://exceleratorbi.com.au/getting-started-dax-studio/ The approach you have described will give a correct answer, but it sounds like the a...
by MattAllington
Thu Jul 26, 2018 7:10 am
Forum: Power Query
Topic: Create connection only in Power BI Desktop
Replies: 1
Views: 296

Re: Create connection only in Power BI Desktop

Yes you can do it. Create the query first. When it is created, while still in the query editor, right click on the query on the left of the screen and "uncheck" enable load.
by MattAllington
Thu Jul 26, 2018 7:08 am
Forum: PowerPivot/DAX
Topic: Problem after upgrade
Replies: 1
Views: 323

Re: Problem after upgrade

I doubt the upgrade caused it, but clearly something has happened. The things that cause circular references are very complex to explain and understand. Is it an Excel circular ref or Power Pivot? If Power Pivot, do you have lots of Calculated Columns? If yes, then you should try to get rid of calcu...
by MattAllington
Thu Jul 26, 2018 7:06 am
Forum: PowerPivot/DAX
Topic: Many to Many filter table problem [Solved]
Replies: 9
Views: 1240

Re: Many to Many filter table problem [Solved]

I suspect the image you have created is not accurate (at a guess). Both relationships state "many to one". But is the relationship between Table A and bridge looks like it should be "one to many". Otherwise I don't think it can be classed as a bridge table. If Table A and Table b...
by MattAllington
Tue Jul 17, 2018 6:21 am
Forum: PowerPivot/DAX
Topic: Online resource for good DAX exercises?
Replies: 1
Views: 290

Re: Online resource for good DAX exercises?

Hi Katja, I hope you are enjoying my book. I recommend that you go to community.powerbi.com and help others with their problems. There is always someone that knows less than you, and helping others is a great way to get practice and learn. Tap on the following link to learn more about my Power BI Bo...
by MattAllington
Fri Jul 13, 2018 8:34 am
Forum: PowerPivot/DAX
Topic: String measure results in evaluation for non-existent relationships
Replies: 4
Views: 613

Re: String measure results in evaluation for non-existent relationships

Effectively yes there is a crossjoin. The job of the relationship is to propagate filters from the one side to the many side. When you place 2 columns from 2 separate source tables in a visual, it creates a crossjoin and then filters out the relationships that don't exists (because of filter propaga...

Go to advanced search