Calculate the Number of Days Between Order Date and Ship Date in Fabric Dataflow Gen2

When working with sales and order data, one of the simplest—and most useful—business questions is: How many days did it take to ship an order? At first glance, this looks like a straightforward subtraction: Ship Date − Order Date = Shipping Days But when you're working in Microsoft Fabric Dataflow Gen2 , there is a little more to it than simply subtracting two columns. The good news is that Dataflow Gen2 uses the familiar Power Query experience, so you can perform this calculation directly during your data transformation process without writing SQL or DAX. Microsoft describes Dataflow Gen2 as