Forum Discussion
Power BI -> Pivot Table. Date column returning as text.
Hello I am translating a power BI -> Power Query to empower some of our analysts to perform excel calculations on our data model. Issue is our time dimension field (Date) returns as TEXT when used...
pcoley
Super User
Super UserZWJ_Create did you check if you have data typed those fields as type text (in the steps you used in the etl done in powerquery while preparing the data in the excel file)?
Hi pcoley , yes current data type for the first column is date. The second column I have tried as Int.32/Int.64/number to no success.
Thanks,
Zack