Use Case: There are many scenarios where we are required to extract the integer portion of a number.

Hence, for 23.57 and for -45.678, the integer portions will be 23 and -45 respectively. 

Power Query Number functions library doesn't provide any function which can do this. Hence, we will work out a formula to make a Number.Int function.

This is an article about specific transformation of split column values.

Organizations face new challenges every day. Priorities change, markets shift, opportunities emerge—the pace isn’t slowing down. As your competitors transform their business models and customer expectations evolve, your future depends on how well you can empower your teams to adapt, innovate, and make a positive impact every day. You need to be ready for disruption, to embrace constant change, and, most of all, be fast on your feet.

In many cases, it involves splitting the value. If it is just a basic splitting of the value, it can be achieved by using Split function in Power query. However, in the following case, the user has different values in each cell with "|" as a separator and needs to remove the separator and sort the values in reverse order based on the date after the separator is removed.

Come meet this months featured user group leaders in Power BI!