Selecting latest run

[rstraum]

Hi all,

quite the newbie using PBI, so please forgive the rather basic question.

I have a table that looks as follows;

Client_ID	Date	Amount	Run_ID
1	14.03.2022	100	1
1	14.03.2022	100	2
1	14.03.2022	100	3
2	14.03.2022	500	1
2	14.03.2022	500	2
3	14.03.2022	900	100
3	14.03.2022	900	115

Any tips on how to select only the latest run_id pr. client_id?

[bhelou]

hi , 

1 - first you should have a date table linked to the table 
2- the dates should be corrected in a propper way like ( DD-MM-YYY ) so on , so in that case you can filter out the latest run or you can make a slicer with a filter for the last day , or to make a measure with the last run date 

hope this will help , if u couldnt do it , please share a sample of the PBIX file , will try to sove it for you . 

[bhelou]

[bhelou]

IF YOU WANT IT LIKE THIS JUST DO AS FOLLOW  from the visualizations: 

1 : select column ID and remove the sum from it 
2 : Date select the latest 
3 : Select the max Run ID