I'm new to powerpivot tables and i'm having trouble creating a formula that calculates margin by region. My data table has revenue and margin for each office (four offices). How do I calculate the margin by office using dax functions?
Put another way - how do I get the office revenue to show up on it's own column for every line? Once I do that I can calculate the margin.
Put another way - how do I get the office revenue to show up on it's own column for every line? Once I do that I can calculate the margin.
Last edited:
