In general, you should not add DAX calculated columns to your data moder if you are able to do what?
Have it added to the data source
Create a measure instead
Create the columns in Power Query during data load
all of these answers