Search found 968 matches

by MattAllington
Thu Jul 26, 2018 7:06 am
Forum: PowerPivot/DAX
Topic: Many to Many filter table problem [Solved]
Replies: 9
Views: 973

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

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

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

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

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

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
Thu Jul 05, 2018 5:39 pm
Forum: PowerPivot/DAX
Topic: If a field contains one of the keywords, return this keyword ?
Replies: 8
Views: 583

Re: If a field contains one of the keywords, return this keyword ?

You could join it to the description. It sounds to me like your data is unstructured, and you need some structure to it if you want to go down this path.
by MattAllington
Wed Jul 04, 2018 6:01 pm
Forum: PowerPivot/DAX
Topic: If a field contains one of the keywords, return this keyword ?
Replies: 8
Views: 583

Re: If a field contains one of the keywords, return this keyword ?

Ok, so this is not really a job for power pivot. This sounds like master data to me. There should be a one time creation of the key words for each product. You need a lookup table of all the products, and a data table of the product codes and key words, like this. Product table ID. Desc 1 Red Apple ...
by MattAllington
Wed Jul 04, 2018 8:28 am
Forum: PowerPivot/DAX
Topic: If a field contains one of the keywords, return this keyword ?
Replies: 8
Views: 583

Re: If a field contains one of the keywords, return this keyword ?

Ok, thanks. I see this as a data preparation task, better for power query rather than power pivot. You say each time text contains “one” keyword. Is it really 1 only, or can there be more than 1? It makes a difference.
by MattAllington
Tue Jul 03, 2018 6:58 am
Forum: PowerPivot/DAX
Topic: Issue with Data Model
Replies: 7
Views: 461

Re: Issue with Data Model

Are you using 32 or 64 bit office? You could try Power BI 64 bit and see if that helps. Sorry, I can’t think of anything else.

Go to advanced search