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

[FC_USER]

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 get all the data before 2019, but when I enter the function below, an error "Cannot convert value '' of type Text to type Integer." is displayed. Why is this?

wtf_test = CALCULATE(COUNTROWS(yozai),FILTER(yozai,yozai[last_action_date] < dateTable[selectedYears]))

----------------------------------------------------------------

------------------------------------------------------------------------

[Mahesh0016 · Accepted solution]

@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]

@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]

@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]

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.

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