Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
You may try adding a measure and drag it to Visual level filters.
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 |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |