Forum Discussion

mathieu_thelot's avatar
mathieu_thelot
Frequent Visitor
10 years ago
Solved

calculate filter Lastdate apply to multigroups (DAX)

I want to do a specific calcul with DAX in power BI. I want to apply last_update function to have the lastupdate cumul_Value of each group :   I have a database looks like :   cumul_Value = sum(...
  • MattAllington's avatar
    MattAllington
    10 years ago

    How about this

     


    cum_value_last_update= CALCULATE( [cumul_Value];
    Lastnonblank( calendar[time],1))

     

    dont put date in the table, just group and the above measure. I think it will work. 

Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

mathieu_thelot

 

Just change the measure as

cum_value_last_update = 
CALCULATE(sum(sampleTbl[cumul_Value]),
FILTER(
ALL(sampleTbl[time]) ,
sampleTbl[time]= MAX([time]) )
)

 

mathieu_thelot's avatar
mathieu_thelot
Frequent Visitor
10 years ago

I try it and that works but not so strong with the Total. 

That retruns for my total the C group value ... 

 

Is there a way to filtrer last value of my groups when dates wasn't the same

 

 

=========================================> time

 

A

============== 03/01/2016

 

B

====== 01/01/2016

 

C

=========================================10/01/2016