Making a 445 Date Table with Power Query
Many organizations, particularly in the retail and manufacturing industries, use a 445 calendar. If yours is such an organization, then you need to “roll your own” (in terms of DAX
Stay up-to-date with the latest customer data news, expert guidance, and resources.
Many organizations, particularly in the retail and manufacturing industries, use a 445 calendar. If yours is such an organization, then you need to “roll your own” (in terms of DAX
Applying standard transformations to several columns at once is a snap in Power Query. Select all the columns, right click on them, go to transform and pick your pleasure. Boom,
Most people are aware that Power Query lets you work with tables that have columns containing other “inner” tables. The classic example is a table representing an Excel workbook where
Once again, October brings an amazing opportunity to attend the Portland SQL Saturday event. If you have never attended, you owe it to yourself to check it out. This all
Lately I’ve been working a lot with Power BI using Direct Query. Historically, if my client was considering Direct Query mode, my automatic response was simply “Nope, bad idea”. My
The addition of the R statistic engine/language to the Power BI platform presents a lot of possibilities for both getting new kinds of data into your model, and displaying information
This is a cool trick that goes hand in hand with Relative Month Index. It shows how to include a slicer that lets the user choose which month they want
The Microsoft Power BI platform provides a variety of architectural options for analytics solutions. These options can be “mixed and matched” as required to satisfy a wide variety of requirements.
Knowledge is power, but only to the extent that it is actionable. Billions of dollars are invested every year in BI and analytics, but what is the actual ROI that
Of all the great things about the new Power BI, there’s one thing not so lovable, and that is the confusion introduced by using the same term to mean yet
Industry leaders choose Skypoint as their comprehensive and compliant Modern Data Stack Platform. A Certified Microsoft Solutions Partner, Skypoint Cloud turns siloed data into connected experiences.