Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Max per group using filter with DAX

Greetings, i have a table with 3 columns: date, machine and signal (there are lots of machines and signals and date is updated daily)   Date Machine Signal 25/03/2021 x A 25/03/2021 x...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous 

    Thanks for your answer, since i have lots of signals i have to use a matrix visual for the columns.

     

    With your help i´ve managed to make a measure that returns exactly what i need, but i have to use two date slicers:

     

     

    This is the measure i used:

     

    MaxPC =
    var fecfin = MAX(Fecha[Date])
    var fecini = CALCULATE(MAX(table[date]),ALLEXCEPT(table,table[equip],table[signal],table[date]))
    return
    DATEDIFF(fecini,fecfin,DAY)
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous 

 

Do you have a Date table with relationship to this table? I have one, the slicer coming from date column from this Date table

test = 
VAR CurDate = SELECTEDVALUE('Date'[Date])
VAR LDate = COALESCE(MAXX(FILTER(yourTable,yourTable[Date]<=CurDate),yourTable[Date]),CurDate)
RETURN
DATEDIFF(LDate,CurDate,DAY)

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous 

Thanks for your answer, since i have lots of signals i have to use a matrix visual for the columns.

 

With your help i´ve managed to make a measure that returns exactly what i need, but i have to use two date slicers:

 

 

This is the measure i used:

 

MaxPC =
var fecfin = MAX(Fecha[Date])
var fecini = CALCULATE(MAX(table[date]),ALLEXCEPT(table,table[equip],table[signal],table[date]))
return
DATEDIFF(fecini,fecfin,DAY)