In this video we discuss the fundamentals of DAX, a powerful formula language used in Power BI. Experienced Power BI users swiftly change between Power Query’s M language and DAX, depending on tasks at hand. We will not be getting into the nitty-gritty details of...
In this video, we discuss the calendar table in Power BI. When building a report in Power BI, it is recommended to create a calendar table. The calendar helps to better organize data and perform a more in-depth analysis using time-intelligence functions. In this...
In this video, we will discuss how to clean and format a sales table using Power Query. Bad data is a big pain for everyone. Data analysts spend most of their time cleaning data, as it rarely comes in the format they need. Power Query comes as a perfect solution to...
In our last week article, we looked at Power BI’s new upcoming visual, smart narratives, which will be a big help for management reporting. However, it was not only the smart narratives visual that caught our attention; with the latest Power BI platform upgrade,...
In this video, we discuss how to clean and transform financial data in Power BI using Power Query. Watch our short video to see how you can quickly transform financial data into a proper database format for further analysis: Finance professionals spend a lot of their...
