Summarise tables with additional incremental column

[alex_liew]

Hi all,

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

From such...

to...

[CheenuSing]

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]

Hi @CheenuSing ,

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