Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Last Date with Filter DAX

Hello There,   I am wondering if I should be using power BI to calculate my last date based on certain condition.   For ex:   I have a below table:   Batch Name| Process Name| Status | last s...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

You should be able to create a measure like:

 

Measure = CALCULATE(MAX('Table'[Date]),FILTER('Table',[Status]="Success"))

Put this in a table along with your columns you specified and you should be good to go.

 

 

Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
9 years ago
@smoupre wrote:

You should be able to create a measure like:

 

Measure = CALCULATE(MAX('Table'[Date]),FILTER('Table',[Status]="Success"))

Put this in a table along with your columns you specified and you should be good to go.

 

 

Greg_Deckler

Just in case, you may use the process date('Table'[Date]) in a slicer,

 

Measure =
CALCULATE (
    MAX ( 'Table'[Date] ),
    ALLEXCEPT ( 'Table', 'Table'[Batch Name], 'Table'[Process Name] ),
    FILTER ( 'Table', [Status] = "Success" )
)