Forum Discussion

ToddMate's avatar
ToddMate
Helper II
6 years ago
Solved

Extract latest transaction: Variable attributes.

Hi    I have a table that contains transactions for a service (service_id) as shown below:   service_id id date_created date_modified direction id new_plan_id old_plan_id result usern...
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    Hi ToddMate 

     

    Use below measure:

    Measure = var a = CALCULATE(MAX('Table'[date_created]),ALL('Table'),VALUES('Table'[service_id]))
return
IF(a=MAX('Table'[date_created]),a,BLANK())

    Then filter the measure is not blank :

v-diye-msft's avatar
v-diye-msft
Community Support
6 years ago

Hi ToddMate 

 

Use below measure:

Measure = var a = CALCULATE(MAX('Table'[date_created]),ALL('Table'),VALUES('Table'[service_id]))
return
IF(a=MAX('Table'[date_created]),a,BLANK())

Then filter the measure is not blank :