Solved: DAX TO M for CONTAINSTRING

Anonymous · ‎11-02-2022

Hello guys i need help to translate a measurement into code m. Can you help me please.

This is my measure in dax and i want this in M.

Colonne = IF(CONTAINSSTRING(Capacity_P1_Planification[Schedules.RefreshSchedule.Days],"Monday"),1,0)

I need to get this result but from the query editor plz

Thank you very much

ImkeF · ‎11-02-2022

Hi @Anonymous

this would be:

if Text.Contains([Schedules.RefreshSchedule.Days],"Monday") then 1 else 0

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

ImkeF · ‎11-02-2022

Hi @Anonymous

this would be:

if Text.Contains([Schedules.RefreshSchedule.Days],"Monday") then 1 else 0

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

DAX TO M for CONTAINSTRING