Data Bear – Power BI Training and Consulting

Call us Today! (020) 8720 6880 | info@databear.com

Johann

Johann is the founder of Data Bear and specialises in help organisations become more Data Savvy. Empowering organisations to move from a time consuming frustration with reporting processes into an automated dynamic interactive visualisations is what he takes pleasure in.

Power BI Tips: Calculate | One of the most used DAX functions

In order to offer meaningful insights from data analysis work in Power BI, it is commonly necessary to perform complex calculations involving all kinds of metrics, sub-totaling functions, data filtering, and relationship handling. For the experienced Power Pivot – Power BI user, the Calculate function of the DAX engine is by far one of the

Power BI Tips: Calculate | One of the most used DAX functions Read More »

Power BI Tips: Discovering Power Query ‘M’ functions

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 »

Power BI Tips: Calculate Year-to-date Values

Power BI Tips: Calculate Year-to-date Values

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 »