Posted inData & Analysis

Filtering a Column via a Visual AND CALCULATE

Sometimes, just when you think you are getting the hang of the DAX language, something happens that completely baffles you. Such events can cause you to doubt your own learning and progress. But let me assure you – this happens to EVERYONE at sometime or another.…
Posted inData & Analysis

Working with Weeks in Power BI

We often need to deal with data over a period of weeks, so we’re going to show you how to use Power BI to work with Weeks. Let’s suppose we have a Sales dataset with Date, Category and Revenue columns and we want to see how…
Posted inDynamics NAV & BC Tips & tricks

AL and SOAP

This sample is based on a page extension for page 8 (Currencies) where an action for downloading exchange rates from the Swedish State Bank has been added. The logic itself isn’t super advanced and it requires SEK as local currency. The focus here is to show…