Forum Discussion

FC_USER's avatar
FC_USER
New Member
3 years ago
Solved

Cannot convert value '' of type Text to type Integer.

I want to create a waterfall chart based on two selected years. When comparing the results of 2019 and 2020, I want to sum the number of data before 2019 and add the data added in 2020. I want to g...
  • Mahesh0016's avatar
    Mahesh0016
    3 years ago

    FC_USER ,
    selectedyear = DATE(CONVERT(MID(CONCATENATEX(VALUES(DateTable[Column]),[Column],""),5,8),INTEGER),1,1)

    FC_USER If this post helps, please consider accept as solution to help other members find it more quickly and Appreciate your Kudos.

Mahesh0016's avatar
Mahesh0016
Icon for Super User rankSuper User
3 years ago

FC_USER ,
selectedyear = DATE(CONVERT(MID(CONCATENATEX(VALUES(DateTable[Column]),[Column],""),5,8),INTEGER),1,1)

FC_USER If this post helps, please consider accept as solution to help other members find it more quickly and Appreciate your Kudos.