Forum Discussion
Solved
Calculation derived from measure
I am new to PowerBI, and so far, I'm not a big fan. I am struggling with a particular project I'm working on for a client. The client is a university that wants to aggregate data by the enrollment st...
when you add a new column in power bi, your formula only sees the current row by default, so you need to use a CALCULATE functin and a filter claus to open up your table so as you are looking at the current row, you can also see all the rows before.
unrortunately, this is not easy for a beginner to do, maybe this link can help you with understanding of how to see more than one row in the table as you add a new column: