Forum Discussion

prashantvns's avatar
prashantvns
Frequent Visitor
9 years ago
Solved

Need help to filter data from table based on latest entry

Hi,   Refering "Existing Data table" basically this an auto test data where  on specific dates different machines "Partition Key"  shows the total number of test case "Count" being executed.   Cu...
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi prashantvns,

    Please use the following formula and get expected result.

    New1 = FILTER('Existing','Existing'[TestRunID]=CALCULATE(MAX('Existing'[TestRunID]),ALLEXCEPT('Existing','Existing'[PartitionKey],'Existing'[TestRunTime])))




    Best Regards,
    Angelia

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi prashantvns,

Please use the following formula and get expected result.

New1 = FILTER('Existing','Existing'[TestRunID]=CALCULATE(MAX('Existing'[TestRunID]),ALLEXCEPT('Existing','Existing'[PartitionKey],'Existing'[TestRunTime])))




Best Regards,
Angelia

prashantvns's avatar
prashantvns
Frequent Visitor
9 years ago

Hi, 

 

Your solution worked but one more thing :) Is it possible to execute this in Query view instead of Data model view.  I need to do this calculation in query view... 

 

Thanks

Prashant