I think you need to load the data to model
then you open the data model
you can add the calculated column in Power Pivot