Search found 7 matches

by Katja_O
Fri Jul 13, 2018 10:53 pm
Forum: PowerPivot/DAX
Topic: Online resource for good DAX exercises?
Replies: 1
Views: 347

Online resource for good DAX exercises?

Hi

Can anyone recommend a good source for DAX exercises with available data?
I am reading the book "Learn to write DAX" but would like to make some more exercises.

Katja
by Katja_O
Wed Jul 11, 2018 5:18 am
Forum: Help with the Book "Learn to Write DAX"
Topic: OR formula does not work (page 67)
Replies: 1
Views: 1258

OR formula does not work (page 67)

Hi

I cannot figure out what is happening with the OR formula. I am trying to make the calculation "Is weekend" on page 67.

Attached is the error that Power Pivot is showing me.

Can anyone see what is wrong with the formula?

Thank you in advance,

Katja
by Katja_O
Thu Jul 05, 2018 5:53 pm
Forum: PowerPivot/DAX
Topic: If a field contains one of the keywords, return this keyword ?
Replies: 8
Views: 911

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

I will try to see what I can do.

Thank you for your help!
by Katja_O
Thu Jul 05, 2018 5:16 pm
Forum: PowerPivot/DAX
Topic: If a field contains one of the keywords, return this keyword ?
Replies: 8
Views: 911

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

Hi Matt

Thank you so much for your reply and demo.

The problem is I do not have a product ID in the Keywords table, so the table with the Keywords and Item name cannot be related.

Is it possible to extract the keyword from the item name without having this relationship?
by Katja_O
Wed Jul 04, 2018 4:13 pm
Forum: PowerPivot/DAX
Topic: If a field contains one of the keywords, return this keyword ?
Replies: 8
Views: 911

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

Hi Matt,

There can be two words as well.
by Katja_O
Tue Jul 03, 2018 11:40 pm
Forum: PowerPivot/DAX
Topic: If a field contains one of the keywords, return this keyword ?
Replies: 8
Views: 911

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

Hi Matt Thanks for your reply. The detailed description of the problem: I have a column with Item number, and a column with Item name. The item name consists of 5-7 words, one of them is a Keyword. I have another table with a list of Keywords. I need to check for each Item name whether it contains o...
by Katja_O
Tue Jul 03, 2018 2:52 am
Forum: PowerPivot/DAX
Topic: If a field contains one of the keywords, return this keyword ?
Replies: 8
Views: 911

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

Hi I have a table with Item number and Item text, and another table with a list of Keywords. I want to check whether Item text contains one of the Keywords, and return this Keyword. How do I do this? Example: Item nr Item text 1 Blue hgffhg 2 Red uuuu 3 PPP Keywords table: Blue Red I need to return ...

Go to advanced search