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


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

bhelou  - thank you for your solution, and especially for the step-by-step images - they were especially useful for a beginner like myself.

 

I got a little confused about how to Expand the column. After the merge I had a column in my data displaying "table". After a little more googling, I realised I simply had to click on the double-arrow icon in the column header and select the column I wanted to bring in/expand. Hope that helps any other newbie like myself that need everything spelt out for them!

 

Regards

RDF