All calculations stopped working

[cknnugget]

Everything was working good. I went into power query and changed a column from "text" to "all" and refreshed the initial problem was fixed. Now no formulas in the entire workbook that reference the table power query imported work. The table name is the same columns are all named the same. How do I fix it. It would take me at least a day to retype all the codes in the workbook.

 

[cknnugget]

Looked back at the query again column by column. When I changed the formatting in one column, it reverted all the columns to their original format. Once the columns were reformatted everything works correctly