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
all of these answers
Create the columns in Power Query during data load
Create a measure instead