help with wildcard character

[summer18]

I know this is easy for you guys but my formula could not seem to work. If you can please help me on the formula in red font

RESULT =
SWITCH(TRUE(),
'Table'[Type]="Series",'Table'[Grade_ Assignment],
'Table'[Type]="Movie" && ISBLANK('Table'[Adviser]) && 'Table'[Title]="Beauty & the Beast",'Table'[Grade_ Assignment],
'Table'[Adviser]
)

Here is my desired result:

Hoping for any assistance.  Thank you in advance

[selimovd · Accepted solution]

Hey @summer18 ,

I think the logic was missing a few parts, but that here should work:

RESULT = 
SWITCH(
    TRUE(),
    'Table'[Type] = "Series",'Table'[Grade_ Assignment],
    'Table'[Type] = "Movie" && (ISBLANK('Table'[Adviser]) || 'Table'[Adviser] = "") && 'Table'[Title]="Beauty & the Beast",'Table'[Grade_ Assignment],
    'Table'[Type] = "Songs" && (ISBLANK('Table'[Adviser]) || 'Table'[Adviser] = "") , 'Table'[Grade_ Assignment],
    'Table'[Type] = "Songs", 'Table'[Adviser],
    'Table'[Adviser]
)

For the next time, please paste a table and not a screenshot of the table. I had to type the whole table by hand now to check the formula...

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[summer18]

Hi @selimovd , thank you very much! It works!  Sorry for pasting the screenshot of the table.  I could not see where I can attach my pbix.

[selimovd]

Hey @summer18 ,

no problem, I'm happy it works 😊

Yes, that's a little bit the problem in this forum, you cannot attach a PBIX file. But you could upload it to OneDrive, Dropbox, SwissTransfer or something similar and post the link.

But you can always post the table as a html table, then I can just paste the values to my PBIX file:

Best regards

Denis