We have created a dataflow and need some basic custom columns e.g. split of Week/Month to Week and Month and using the Week to find out the first date of the first day of that week
We did that in Desktop initially but now want to do data preprepation in a dataflow
So we took the Advanced editor code from Desktop and used that in the dataflow. Looks like it worked and now columns were created correctly
BUT when we save the dataflow and access it from a new PBI desktop - We do NOT see these new columns. They are not saved in the dataflow definition. When we open the data flow itelf we see the new custom columns but not when when we open it in a desktop
Can we create custom columns in a data flow using advanced editor? If so why cannot we use them as a data source?