Forum Discussion
caslus
Helper I
6 years agoMax date and value by date filter slicer (dinamic)
The archive : https://transfernow.net/215t88x2cpeh This is my table... and my filter: If I put the filter 13/8/2019 to 5/09/2019... I want show just the yellow part and make a sum of thos...
- 6 years ago
I got a new measure, It seems to give correct GT and correct values when view NUM_DPL. But when view by NUM_DOL and date , it does not show correct value, figuring out that
Total value = Calculate( sumx( ADDCOLUMNS( SUMMARIZE( data, data[NUM_DPL], "max_date", MAX( 'Date'[Date]), "Max_ID", max(data[NUM_DPL]) ), "_num", calculate( Max(data[VLR_SLD_TOT_CAL]), filter( (data), data[NUM_DPL]= [Max_ID] && data[DAT_REF]= ([max_date]) ) ) ) ,[_num] ) )
amitchandak
Super User
6 years ago🤔, why only that row. If possible please share a sample pbix file after removing sensitive information.Thanks.
My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
caslus
Helper I
6 years ago