Forum Discussion

RDF25087's avatar
RDF25087
Icon for Helper I rankHelper I
3 years ago
Solved

Add latest date by item to data

Hello!   Another day, another Power BI issue...   I have a dataset consisting of a unique list of customers, something like this: Contract ID Customer Name Sales Person Post Code Area 1...
Need Help
  • bhelou's avatar
    bhelou
    3 years ago

    Dear , 

    In power Query do the same as follow : 

    1 - Group list 2 by max date 
    2 - Merge Queries in list 1 with list 2 
    3- Expand List 2 , it will show up the max date that match with the contract ID 

    Attached Images and Attached PBIX file link 

    https://www.dropbox.com/s/e13zbo13scm5myt/Max%20Date.pbix?dl=0 

    Regards , 

    Kindly accept as a solution and a kudo is appreciated . 

    List 2 OriginalGroup By Max DateList 1 OriginalMerge list 1 and 2 ,Expand max dateReport


bhelou's avatar
bhelou
Icon for Responsive Resident rankResponsive Resident
3 years ago

Dear , 

In power Query do the same as follow : 

1 - Group list 2 by max date 
2 - Merge Queries in list 1 with list 2 
3- Expand List 2 , it will show up the max date that match with the contract ID 

Attached Images and Attached PBIX file link 

https://www.dropbox.com/s/e13zbo13scm5myt/Max%20Date.pbix?dl=0 

Regards , 

Kindly accept as a solution and a kudo is appreciated . 

List 2 OriginalGroup By Max DateList 1 OriginalMerge list 1 and 2 ,Expand max dateReport