Search found 947 matches

Tue Jul 17, 2018 6:21 am
Forum: PowerPivot/DAX
Topic: Online resource for good DAX exercises?
Replies: 1
Views: 11

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.
Fri Jul 13, 2018 8:34 am
Forum: PowerPivot/DAX
Topic: String measure results in evaluation for non-existent relationships
Replies: 3
Views: 70

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

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
Wed Jul 11, 2018 2:27 pm
Forum: Help with the Book "Supercharge Power BI"
Topic: errata
Replies: 0
Views: 17

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...
Wed Jul 11, 2018 2:27 pm
Forum: Help with the Book "Supercharge Power BI"
Topic: errata
Replies: 0
Views: 64

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...
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: 186

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.
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: 186

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 ...
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: 186

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.
Tue Jul 03, 2018 6:58 am
Forum: PowerPivot/DAX
Topic: Issue with Data Model
Replies: 7
Views: 114

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.
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: 186

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...

Go to advanced search