In this video I demo how to create a waterfall chart for a Profit and Loss statement based on the IBCS®️ standard. I'll demo this in the standard Power BI visuals as well as in Charticulator. Using this standard it is far easier for report users to get insight into the financials of an organization.
When you have a table that contains events with a start and an end dat, you sometimes need to expand it out so that you have a row for every day in between the start and end date. This video will show how to do that both in Power Query and in Power BI.
Understanding and debugging your #DAX in #powerbi just got much easier and faster with the DAX Debugger tool in Tabular Editor 3. In this video, I demonstrate the tool with some DAX that doesn't give the expected result. And I show you how to use the debugger to find the cause [...]
In the world of DAX formulas, the two formulas that get mixed up the most are FILTER and CALCULATETABLE. This is due to the fact that they actually produce the same result in certain scenarios. For example, when a Matrix is created on the canvas in which a filter is applied to a single dimension table (in [...]