Forum Discussion

Regular Visitor

3 years ago

Solved

Group by

Hi everyone, I am struggling with grouping the below set of data: 1) Firstly, I want to group the highlited columns. My final result should be: one row with date and total amounts for both colum...

AnkitKukreja
3 years ago
Hi alice25

Here you go:

Attaching the file for your reference.

Group by.pbix26 KB

Super User

3 years ago

It would be great if you can share the sample data with me and the expected output.

alice25
Regular Visitor
3 years ago
Hi Ankit,

Sample data:
Last date of the week Incoming Shipment Backlog
12/25/22 0 1291.03 25237
12/25/22 0 0 25237
12/25/22 null null null
12/25/22 0 0 25237
12/25/22 0 14573.53 26528
12/25/22 0 0 31143

Expected:
Last date of the week Incoming Shipment Backlog
12/25/22 0 15864.56 31143

Thank you!
- AnkitKukreja
  Super User
  3 years ago
  Hi alice25
  
  Here you go:
  
  Attaching the file for your reference.
  
  Group by.pbix26 KB
  - alice25
    Regular Visitor
    3 years ago
    Hi Ankit,
    
    Thanks! There is one issue with backlog value - it will not be always max value.
    
    Please find below the example:
    Last date of the week Incoming Shipment Backlog
    12/18/22 5036.31 0 31782
    12/18/22 0 0 31143
    12/18/22 0 1988.02 31143
    12/18/22 0 0 26746
    12/18/22 0 0 26746
    
    Expected:
    Last date of the week Incoming Shipment Backlog
    12/18/22 5036.31 1988.02 26746