Forum Discussion

rstraum's avatar
rstraum
New Member
3 years ago

Selecting latest run

Hi all,

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

 

I have a table that looks as follows;

Client_IDDateAmountRun_ID
1

14.03.2022

1001
1

14.03.2022

1002
1

14.03.2022

1003
214.03.20225001
214.03.20225002
314.03.2022900100
314.03.2022900115

 

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

Need Help

3 Replies

  • bhelou's avatar
    bhelou
    Responsive Resident
    3 years ago

    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's avatar
        bhelou
        Responsive Resident
        3 years ago

        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