Ignore dax change on the calculated column

[Chifflee]

Hello Guys,

I would like to ask your help because since the October update I can't modify the calculated columns. 

So, I had to create a calculated colum today which worked properly, here the formula:

Stations =

var s=RELATED(tStations[stationName])

var s2=RELATED(tStations[Old stations name])

var d =tLPMS[shiftDate]

return

IF(tLPMS[shiftDate]<DATE(2020,10,20),s2,s)

But, I made a mistake on the date, so I changed from DATE(2020,10,20) to DATE(2020,10,19). And nothing changed....
I deleted the formula and placed with this: Stations =1

And nothing changed....

Any idea?

Thanks!

[MFelix]

Hi @Chifflee ,

On my side everything is working properly I can change columns calculations and everything updates accordingly. Does it return any error message or code?

Have you tried to unninstall  and install PBI again?

[Chifflee]

Hi @MFelix ,

No error message (it seems the calculation updated and run, but the values are same on the column), but the text arrange can changes (you know when the text type is a whole number, text arranged to the another side).
By the way, I noticed that if I arrange the column from A to Z or whatever, updates correctly.
It seems I can solved it to close the file without save and create calculated column without any mistake... 

[v-lionel-msft · Accepted solution]

Hi @Chifflee ,

What happens if you refresh the file? Or restart the desktop? Or clear the cache in 'Options and settings'?

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.