With the introduction of Power Fx, Microsoft has recently released the preview of formula columns which will be very similar to our Excel experience. Now it’s on the fly formula as not saved anywhere but we can expect this to be written to the tables as well. Intellisense makes the life of the administrator/developer who creates the columns as they can select from what is available to include in the formula. This is going to be game changer when we start thinking about the columns in data verse. More detailed documentation regarding this feature is available here. Check this out for sure. I am checking it right away.