In this blog post, you will learn how to use the DATEDIFF function in DAX to calculate, Get DATEDIFF in Hours Here we have 2 columns in the DateTime data type. Order Date and Delivery Date. Let’s calculate the number of hours it took to complete the order. Create a new column. Here is the
Month: February 2023
1. Leading Zero to month number – Text.PadStart( ) Here we have a month column on Power Query in text data type. Ideally, we want to convert single-digit values to 2 digits by adding a zero in front and if the number is already 2 digits, do nothing. Create a new custom column and add