Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi GunnerJ
According to your description, it seems that you want to show only data with “service ” group, right? If so, think you could use below expression to create new table (replace Table1[type]="c"|| Table1[type]="a" with your condition)
Table = ADDCOLUMNS ( SUMMARIZE ( FILTER ( Table1, Table1[type] = "c" || Table1[type] = "a" ), Table1[id], Table1[type], "mind", MIN ( Table1[date] ), "maxd", MAX ( Table1[date] ) ), "datediff", DATEDIFF ( [mind], [maxd], DAY ) )
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@dax specifically I'm wanting just the "Min Time" date to filter down to the work group "Service". Sequences often end with tasks that don't have a specific workgroup so I'm just trying to find the different between the first task of workgroup = Service and the max date.