Forum Discussion
circle dependency
Hi, i am trying to add calculated measure. The best way to do this is to give the formula in Excel. For column D6 it is: =IF(A6=$A$9;100%;IF(A6<$A$9;D5*(1+C5);"")). So that means I need the values from the previous cell to calculate the other cells. I have already defined columns A and C as a measure in PBI, I only have problems with D because I cannot refer to the entries in the formula. I would be really grateful if you can help me!
Can you share an excel file with the same format but dummy data.
A measure doesn't inherently have a sense of row order so would need to understand more about what you're doing and what determines row order. Sure there are ways of achieving it but often need either an index column building or use of OFFSET.
This is what I want to do:
Measure= IF(SELECTEDVALUE(QYear[QYear])=max(Index[Year]),100,IF(SELECTEDVALUE(QYear[QYear])<max(Index[Year]),(1+Index[IndexValues])*Index[Measure],BLANK()))
The Measures QYear, Year, IndexValues have already been created. "Index[Measure]" is the Problem
Hi, nisi
Can you provide sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with Excel. I look forward to your response.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,here are two screenshots of the file. I want to create the "Change" column in PBI as a measure or column with a formula. I have already created the other two columns. ("Wenn" means IF)
Thank you!
