Search found 946 matches

by MattAllington
Fri Jul 13, 2018 8:34 am
Forum: PowerPivot/DAX
Topic: String measure results in evaluation for non-existent relationships
Replies: 2
Views: 50

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

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

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

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

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

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

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

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.
by MattAllington
Tue Jul 03, 2018 6:40 am
Forum: PowerPivot/DAX
Topic: If a field contains one of the keywords, return this keyword ?
Replies: 8
Views: 183

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

This doesn’t sound like a DAX task, but maybe a power query task. The general pattern is to optimise and prepare your data before loading to power pivot rather than trying to solve such issues in DAX. Can you give a more detailed description of the problem you are trying to solve? Or you could use t...
by MattAllington
Tue Jul 03, 2018 6:27 am
Forum: Help with the Book "Learn to Write DAX"
Topic: Error on Page 52
Replies: 1
Views: 93

Re: Error on Page 52

Hi YettyB. I assume you mean Learn to Write DAX. This book is 30 months old, and no one has every pointed this out to me :shock: This was fixed in my new edition, but obviously doesn’t solve this problem. The sentence refers to the table above, not below, and the “red” is the “box” drawn on the pivo...

Go to advanced search

cron