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.

FC_USER's avatar
FC_USER
New Member
3 years ago

Mahesh0016 

Thanks.But The result did not

Do you know how to keep later years from multiple selected years in slicer as values for comparison?

 

wtf_前年度繰越 = 
CALCULATE(COUNTROWS(yozai),FILTER(yozai,yozai[last_action_date] < dateTable[selectedyear]))

 

 

 

 

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

    FC_USER 

    Please Try this one , if you compare multiple Year Selected 

    wtf_前年度繰越 = 
CALCULATE(COUNTROWS(yozai),FILTER(yozai,yozai[last_action_date] IN {dateTable[selectedyear]}))


     

    • FC_USER's avatar
      FC_USER
      New Member
      3 years ago

      I get that same error...

      If you give the date directly, it will show the value

       

      MdxScript(Model) (42, 39) Calculation error on measure 'dateTable'[selectedyear]: value '' of type Text cannot be converted to type Integer.

       

      ーーーーーーーーーーーーーーーーーーー