DAX measure not working

[Anonymous]

Weighted Average Spread =

DIVIDE([ANI*SPREADCURRENT], SUM('Pipeline'[ANI]))

So I've been using this DAX measure on the same report and same visuals for the past few weeks however, this morning when I've refreshed my report it has caused an error saying the sum does not work with string values. 
I haven't changed anything in my data, any ideas whats going on?

[tex628]

Hi, 

Sounds like something has occured in your sourcedata within the [ANI] column. I'd start by going into power query and making sure that you convert the column into a numeric datatype. If this returns an error there should be a value within the column that is incorrect. 

/ J

[amitchandak · Accepted solution]

@Anonymous , check, seem like datatype of one of the column has changed or updated . Check the columns below the measure. Under column tools . when you click on column it will show.

Also check data type in power query. Or check any datatype error in power query

correct that and make it number data type

[Anonymous]

Thank you so much! That helped correct everything.

However, I haven't touched that formula or table in a while so I dont understand why it would suddenly change?