A major part of the ‘power’ which Power BI offers, can be attributed to a powerful self-service ETL tool in Power BI, called Power Query or otherwise known as the ‘Edit Query’ functionality in Power BI desktop. With a simple Graphical user interface (GUI), it can consume data from almost all data sources. It also
Power BI Tips: Discovering Power Query ‘M’ functions Read More »
You’ve probably faced a data analysis scenario of having to calculate year-to-date values to meet reporting specifications. And of course, for most data analysis cases involving dates, YTD is a widespread de-facto standard of evaluation. As some of you may have experienced, achieving year-to-date analysis, based on a selected year and period, in Excel is
Power BI Tips: Calculate Year-to-date Values Read More »
Welcome to our first of the Power BI Tips series. Over the past two weeks, I have been asked the same question by people who have just started the awesome journey towards revolutionizing their reporting experience through Power BI: “Instead of the default alphabetical sorting, how do I sort the months in my charts by
Power BI Tips: Sort by Month Name Read More »
