Forum Discussion
Reference a Measure in a Table Cell
Otto_Luvpuppy , you can not refer a measure in a column, But you can create the below formula
new measure =Switch( True(),
Max(Table[column]) = "19/20-P13", [Overdue]
Max(Table[column]) = "20/21-P1" ,[Overdue]*0.9
Max(Table[column]) = "20/21-P2" ,[Overdue]*0.8
Max(Table[column]) = "20/21-P3" ,[Overdue]*0.7
Max(Table[column]) = "20/21-P4" ,[Overdue]*0.6
Max(Table[column]) = "20/21-P5" ,[Overdue]*0.5
Max(Table[column]) = "20/21-P6" ,[Overdue]*0.4
)Take care of row context while using
You can take measure into another measure directly without any aggregation.
New Measure = [Measure]*0.78
Is there any logic on multiplication factor (i.e. 0.4,0.5 etc.) ?
Hi...thanks for the help...yes the reason behind this request is that I'm trying to build a decreasing 'target' across the 6 period dates. The only information I have is a static figure for Period 13 and that they want to reduce this by 60% when they get to Period 6. So it's a flat line and works out as a 10% decrease each period based on the original Period 13 figure.
Regards
