Search found 992 matches

by MattAllington
Tue Jul 31, 2018 7:32 am
Forum: Power Query
Topic: Pulling Data from Stacked Column with No Pattern
Replies: 4
Views: 852

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

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

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

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

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

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

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...
by MattAllington
Thu Jul 12, 2018 7:27 am
Forum: PowerPivot/DAX
Topic: Continous Date [Solved]
Replies: 2
Views: 563

Re: Continous Date [Solved]

You can probably do it in DAX, but how about you take a look at my video showing how you could do this in Power Query. https://www.youtube.com/watch?v=xN2IRXQ2CvI
by MattAllington
Wed Jul 11, 2018 2:27 pm
Forum: Help with the Book "Supercharge Power BI"
Topic: errata
Replies: 0
Views: 721

errata

In this post, I will share with you the errors noticed after the book is published. Chapter 17 Here’s How: Creating a Morphing Switch Measure In the definition of the measure [Measure to Display], the measure [Selected Measure] is given as [Selected Value]. Chapter 15 Writing Custom Time Intelligenc...
by MattAllington
Wed Jul 11, 2018 2:27 pm
Forum: Help with the Book "Supercharge Power BI"
Topic: errata
Replies: 0
Views: 1380

errata

In this post, I will share with you the errors noticed after the book is published. Chapter 17 Here’s How: Creating a Morphing Switch Measure In the definition of the measure [Measure to Display], the measure [Selected Measure] is given as [Selected Value]. Chapter 15 Writing Custom Time Intelligenc...

Go to advanced search

cron