Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Calculating the difference between Dates stored across different records in the same table

Hello All,   We have a sales history Table associated with the Opportunity Table. (1 Opportunity with multiple Sales History) The Sales History table last has a modified date and Status date. I'm ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Group on the field that allows the sales history table to merge with the opportunity table. The code below shows the grouping with a sample table in Excel as the sales history table.

 

let
    Source = Excel.CurrentWorkbook(){[Name="SalesHistory"]}[Content],
     #"Grouped Rows" = Table.Group(Source, {"Order"}, {{"Modified", each List.Max([Modified]), type datetime}})
in
    #"Grouped Rows"