Forum Discussion
Unable to use string columns in any way in DirectQuery mode.
Hi guys, I'm using direct query to get the data from an OLAP cube. The columns Dim_date, Fiscal_year, Fiscal_week, FY, FP, etc are not available in the DAX expression box when typing. This the er...
what is the format of the FP column in the cube?
if its a string you may need to convert it to a number. Unsure of your system but StrToValue might help, or be a starting point.
I believe StrToValue is not part of DAX's functions and I don't have access to the cube, so there's no way of knowing the format through the backdoor or any way