topic Re: Cannot convert value '' of type Text to type Integer. in DAX Commands and Tips

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

FC_USER — Mon, 16 Jan 2023 05:30:12 GMT

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

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

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

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

Mahesh0016 — Mon, 16 Jan 2023 06:36:45 GMT

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.

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

FC_USER — Mon, 16 Jan 2023 06:57:05 GMT

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

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

Mahesh0016 — Mon, 16 Jan 2023 07:08:22 GMT

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]}))

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

FC_USER — Mon, 16 Jan 2023 10:30:33 GMT

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.

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