Text Extract - M Query

[Anonymous]

Hi frds,

I have query for Edit Query mode, need result DAX/M Quey. 

I need Colour type from Description column, maybe it will add new colour also in future.

Thanks,

KV

[Ashish_Mathur]

Hi,

If you can share a master list of all possible colours which can be found in the Description column, then i can solve this problem with a DAX formula.

[amitchandak]

@Anonymous , using switch true or if create a color measure like thsi

Color Date = if(FIRSTNONBLANK('Date'[Date],TODAY()) <today(),"lightgreen","red")

or

color =
switch ( true(),
FIRSTNONBLANK(Table[commodity],"NA") ="commodity1" && sum(Table[Value]) >500,"lightgreen",
FIRSTNONBLANK(Table[commodity],"NA") ="commodity2" && sum(Table[Value]) >1000,"lightgreen",
/// Add more conditions
"red"
)

In conditional formatting use "field" and the color measure

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column

Please Watch/Like/Share My webinar on Time Intelligence: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184
My Youtube Tips at: https://www.youtube.com/playlist?list=PLPaNVDMhUXGYrm5rm6ME6rjzKGSvT9Jmy

Appreciate your Kudos.

[Anonymous]

Hi @amitchandak ,

I need extract colour name in the description column.

Thanks,

KV

[v-lionel-msft]

Hi @Anonymous ,

Or Transform -> Split Column.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Pragati11 · Accepted solution]

Hi @Anonymous ,

You can use Transform --> Extract --> Extract between delimiters in Edit query on your Description column.

Try this option with differet delimiters whichever works for you.

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati