Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

DAX TO M for CONTAINSTRING

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

Need Help
  • ImkeF's avatar
    ImkeF
    3 years ago

    Hi Anonymous 

    this would be:

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

     

1 Reply

  • ImkeF's avatar
    ImkeF
    Community Champion
    3 years ago

    Hi Anonymous 

    this would be:

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