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

prashantvns's avatar
prashantvns
Frequent Visitor
9 years ago

Thanks for your help but the solution you have given is not working fully :( and I still need  your help

 

 

If you see that the count for TestRunID(2) is 1308 but in your solution it come as 1302

to conclude the final row should be A-----7/17/2017------2-----1308.  

Thanks again and wating for your resposne 

 

 

 

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft 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