Forum Discussion

mmvohra's avatar
mmvohra
Icon for Helper II rankHelper II
6 months ago
Solved

Need help regarding fine measure formulation

I want to make measure as per the following logic: Filter table → only rows where [Dif KM_1] <= ParameterValue. Within each Consolidated ID: Find minimum date. Find the immediate date after the m...
Need Help
Show and Tell
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
6 months ago

Hi,

The answer should be 20000.  I think the formula in cell I7 is wrong - it should be =[@Price]-$E$6.  PBI file attached.

  • mmvohra's avatar
    mmvohra
    Icon for Helper II rankHelper II
    6 months ago

    I want table to be dynamically filtered based on parameter value and once the table is dynamically filtered only then it can sum up the difference between consecutive for each consolidatedID