Forum Discussion

Jameswh91's avatar
Jameswh91
Helper III
4 years ago

Profit Margins

Hi, I'm looking for the best way to calculate the profit margin for our shopify data. Is it best best to calculate measures for the profits and the margin or calculated columns?

 

Any help would be much appreciated

Need Help
Show and Tell
Tips and Tricks

1 Reply

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Most Valuable Professional
    4 years ago

    Measure is the way as far as your need is concerned. Calculated columns should be avoided as much as possible. Measures are very much optimized by Power BI's Vertipaq engine.