This tutorial will focus on currency conversions and how to format these converted currencies using DAX in Power BI. In this example, Sales will be used to run a report based on different currencies from World Wide Importer’s data. Assumptions Used These are the assumptions that you should remember in this remodelling: Creating The Currency
In this tutorial, we’ll go through a technique that will create a lookup table from subtotals using the query editor in Power BI. This is most useful when we’re getting data out of Microsoft Excel because most of its data will contain subtotals. We’ll be using some oil and gas statistics found online. Subtotals In
In this tutorial, I’m going to show you how to create unique subtotals in your Power BI tables using the SWITCH TRUE logic. This is a breakout session from a financial reporting course released by Enterprise DNA. The session includes a detailed application of a variety of financial reports such as income statements, balance sheets,
