When it comes to deal with the direct query, most of us think that columns are not allowed. But this is not true. We can directly create columns to let us explore more.
It is amazing how much more efficient it is to complete reasonably technical analysis with Power BI. One business scenario where this will bring huge value to an organisation is when looking to understand your customers better.