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. 

MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
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.