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