Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Table 1:
Table 2:
Here my existing formula to calculate the total value based on table 1,
//company A,B,D >12MTHS
Sum({Table 2.Company-={'C'}
[> 24 MTHS]+[13-24 MTHS])
//company C >24MTHS
+Sum({<Table 2.Company={'C'},Table 2.Company -={'A', 'B', 'D'}>}
[> 24 MTHS])
Since table 1 may change, I want to change the measure dynamically, e.g if table 1 A aged ='>24MTHS', Change the formula measure to sum( [> 24 MTHS]).
Should I join table 1 and table 2 and then using if case to determine total MTHS value?
Is it a better way to calculate the total MTHS value based on table 1 column B?
Please help😥
i seems found the solution, i use
Pick(WildMatch(
to solve this problem