Different values in Power Query editor than Table Visual

[CBVC-HB]

I've been getting a strange issue, it didn't used to be like this and I haven't changed the Power Bi Report. I have a table with prices that I update a couple times a month, I usually just press refresh and it refreshes the table and I export it. However I've noticed recently that it's not updating the values for some custom columns I made which is just adding VAT to the prices. On the query editor it's doing the calculation but those calculations are not applying on the table visual and it's just giving me the same value without VAT added. 

Does anyone know how to fix this issue? I press Close and Apply on the query editor and it doesn't change it. Refresh doesn't change it and I've tried closing and opening it again but the values aren't changing. Making a new table with the same columns gives me the same values. Not sure what to do.

[MNedix · Accepted solution]

Hi,

Are you using the query columns "as-is" in your table or are they measures? If so, maybe there is a filter in the measure. Also, are you sure you have the correct formatting of the columns?

[CBVC-HB]

Sorry I had to edit the original post, I realised the columns in the table were in a different order than the query editor so the values are updating, it's just the custom columns adding VAT that are not updating and just keeping the same non VAT value. I could make these columns instead through a measure? 

Edit - Nevermind I fixed it. Just an issue with the custom column formula 😅