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.

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.

     

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