Forum Discussion
How can we calculate row values for a row depending upon values in remaining row
I want to calculate the missing values for the row New Department which has the following calculation which is based on the values in other rows. Department Sub-Department Col1 Col2 Mont...
Sean
Community Champion
Community ChampionOkay IF I understand what you are really asking the answer is you can't do this in PBI or even Power Pivot
"DAX works on Tables and Columns NOT Cells"
You want to have values in Col2 and then a formula in the bottom row of Col2?
At least that's how I understand your question from the sample table you've posted!
