Forum Discussion

refkabeji's avatar
refkabeji
New Member
3 years ago

Multiple columns cannot be converted to a scalar value

Hi guys I would ask you about how can I compare values from table to measure . END_DATE_ESP = var tmp =     SELECTCOLUMNS ( Table_param_version, "SelectColumn1", [version] ) VAR _str =     ...
Need Help
refkabeji's avatar
refkabeji
New Member
3 years ago

hello ahmed

datevalue(SWITCH(_str, "Actualisé",concatenate(concatenate(concatenate(CONCATENATE([Day_selected1],"/"),[Mois_selected1]),"/"),_str2+1),"Provisoire",concatenate(concatenate(concatenate(CONCATENATE([Day_selected1],"/"),[Mois_selected1]),"/"),_str2)))

yes It contains datevalue but It does'nt word.

may be because I compare column with measure ?

  • Ahmedx's avatar
    Ahmedx
    Icon for Super User rankSuper User
    3 years ago

    Can you please share your demo input and expected output!

    • refkabeji's avatar
      refkabeji
      New Member
      3 years ago

      Hello guys

       

      My input is : 

       

       

      I would compare column in my fact table with this mesure :

      how can I compare Mesure with column

       

       

      thank you