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_ID Date Amount Run_ID 1 14.03.2022 100 1 1 14.03...
Need Help
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

    • 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