If you’ve ever encountered a memory warning while running a query in Power BI Desktop, you know how frustrating it can be. Not only can it slow down the performance of your report, but it can also cause your report to crash. In this article, we’ll explore what causes memory warnings in Power BI Desktop, […]

Power BI is a business intelligence (BI) platform developed by Microsoft. It is a powerful tool that allows users to collect, analyse, and visualise data. Power BI is used by businesses of all sizes to make better decisions. In 2023, the growth of Power BI is expected to be driven by five major trends: The […]

A special case of the PARALLELPERIOD function: NEXTYEAR, NEXTQUARTER, NEXTMONTH and NEXTDAY — create a column with dates of the previous year, quarter, month and day. creating a column with the dates of the next year, quarter, month and day. PREVIOUSYEAR, PREVIOUSQUARTER, PREVIOUSMONTH and PREVIOUSDAY — creation of a column with the dates of of […]

Data analytics is the process of storing, organising, and analysing raw data to answer questions or gain important insights. Data analytics is integral to business because it allows leadership to create evidence-based strategy, understand customers to better target marketing initiatives, and increase overall productivity. Companies that take advantage of data analytics reap a competitive advantage […]