How to build sankey chart using monthly snapshoots

[bsas]

 Hi all,

I'm trying to build sankey based on monthly snapshoots in selected period, where start date is min snapshoot date in period and end date is max snapshoot date in period. We should ignore all other snapshoots within the period. 

example of my table

ID	date	stage
111	1/31/2018	2
111	2/28/2018	3 (ignore it)
111	3/31/2018	3
222	2/28/2018	2
222	3/31/2018	3 (ignore it)
222	4/30/2018	3 (ignore it)
222	5/31/2018	4

same table if we change period 

ID	date	stage
111	1/31/2018	2
111	2/28/2018	3 (ignore it)
111	3/31/2018	3
222	2/28/2018	2
222	3/31/2018	3

Will appreciate any help with this.

[v-chuncz-msft]

@bsas,

You may try adding a measure and drag it to Visual level filters.

[bsas]

Thanks @v-chuncz-msft,

In my case I need to create calculate column which will ged value from min date in selected period (same for max) and set it for all record in appropriate ID (e.g. in case I have 4 raws with same ID and 4 dates column should get value from date raw which <= min date in period. Same approach for Max. I need this min and max as calculated column because will use it as source and destination in sankey chart.

ID	date	stage	min	alternative min	max	alternative max		period 1/20/2018 - 5/2/2018
1111	1/31/2018	2	2	2	4	4
1111	2/28/2018	3	2		4
1111	3/31/2018	3	2		4
1111	4/30/2018	4	2	2	4	4
ID	date	stage	min	alternative min	max	alternative max		period 2/10/2018 - 4/24/2018
1111	2/28/2018	3	2	2	3	3
1111	3/31/2018	3	2	2	3	3