Forum Discussion

alex_liew's avatar
alex_liew
Frequent Visitor
7 years ago

Summarise tables with additional incremental column

Hi all,

 

Ideally I would like to summarise a table with additional column that measure the occurences...

 

From such...

to...

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi alex_liew ,

     

    Is this summary table going to be used as a visual or as a table in data model ?

     

     

    Can you explain the logic to form the groups like SupplierID by Start and EndDate. 

     

    Also the measure number of occurences.  For every Supplier by Start and Endate without breaks is it to be incremented by 1.

     

    Can you upload sampledata ( not picture ) , pbix and output expected to Google/One Drive and share the link here to find a solution.

     

    Cheers

    CheenuSing

     

     

     

     

    • alex_liew's avatar
      alex_liew
      Frequent Visitor
      7 years ago

      Hi Anonymous ,


      The dataset shows how much each supplier has delivered per day at a mininum.  Some days there are no delivery hence 0.

      I would like this dataset to be summarised or grouped  so I can determine how many occurences each supplier have delivered continously and the duration in days. 

      Each occurence is determine by the group of dates and supplier ID, for example supplier abc deliver x amount over 5 days and break for 2 days and begin its delivery again.  This would be considered as 2 delivery occurences and will required a measure to work out the days duration for each occurence.

      I would then like the data to be displayed as a table visual.

       

      Thank you.

       

       

      Here's a link to the PBIX file that contain sample dataset.

       

       

      Cheers,

      Alex