Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Contains function not returning the correct value

Hi All, I have written the below code but it is not giving me expected result. Can anyone suggest me where I'm doing mistke.   Measure 2 = CONTAINS(YOY_Cumulative,'YOY_Cumulative'[Name],"2015") ...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi Anonymous 

    Use this measure

     

     

    Measure 2 = CONTAINSSTRING(MAX('YOY_Cumulative'[Name]), "2015")

     

     

    Regards

    Phil

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , try of this can work

containsstring('YOY_Cumulative'[Name],"2015")