How OFFSET in DAX will make your life easier

Data - Marc

Over the past few days, I attended the Power BI Next Step conference in Lego land – Denmark. During the keynote, Will Thompson – PM on the Power BI team, showed a new DAX function that is available to all of us already, but was very well hidden in the latest builds of Power BI Desktop. This new function, called OFFSET, allows us to do in context comparisons between two values, without writing extremely lengthy and complex DAX.

I gave it a go and in this post I share my first experiences with this new function and how I think this will make our life easier!

Ursprünglichen Post anzeigen 916 weitere Wörter

Power BI Datamarts, should I use it or not?

Data - Marc

The first post after my vacation. I was in doubt for a while whether I should write this one or not… given the preview state. Since one of the customers I work for asked me for advise today about Power BI Datamarts, I thought lets do it! They convinced me that it would be a valuable blog for many. I hope for you too.

What is this blog about? I will explain my first experiences with Power BI Datamarts which is currently in preview state. I will elaborate on my test cases, the value I see in Datamarts but also some open ends and where you can potentially position it in your Power BI solution architecture.

Ursprünglichen Post anzeigen 2.450 weitere Wörter

Dynamics BC – New Email features

In the past two years I have developed a rather complex emailing solution. I’m making heavy use of the codeunit 400 SMTP Mail which is now longer available in the new version.

So it’s time to make myself feel confident with the new email features. For a quick start I can recommend these two blog posts

https://yzhums.com/7485/

https://dankinsella.blog/developing-with-the-new-enhanced-email-feature/

Exam DP-500 (beta): Prove your skills as an Azure enterprise data analyst

https://docs.microsoft.com/en-us/learn/certifications/exams/dp-500

https://techcommunity.microsoft.com/t5/microsoft-learn-blog/exam-dp-500-beta-prove-your-skills-as-an-azure-enterprise-data/ba-p/3279435

As I mentioned several times before I love taking beta exams. So I will give this one a go also.

In order to prepare for exam DP-500 I can highly recommend the content on the Data Mozart homepage. I think the articles are well written and it Is always easy to follow the content. For example I really enjoyed the blog post about Creating Calculation Groups.

https://data-mozart.com/category/mastering-dp-500/

Dynamics 365 Business Central 2022 Wave 1 loves Power Automate

Stefano Demiliani

Are you a Power Automate user? Are you using workflows to Automate your tasks in Dynamics 365 Business Central? If so, there are good news for you in the air…

The next 2022 Wave 1 version (or version 20) gives you an interesting new feature: the ability to trigger a Power Automate flow directly from Business Central.

What does that means?

This new feature will permit you to create and connect to Dynamics 365 Business Central your instant flows from Power Automate and execute a selected flow in the context of the selected single record (using actions launched from any card page).

Every card and document page that runs in the context of a data table now features a newAutomategroup in the action bar. From that group, users can run manual flows defined for Business Central.

How does it work?

This feature is not switched on by default…

Ursprünglichen Post anzeigen 300 weitere Wörter

Business Central Universal Code initiative: are you really so surprised?

Stefano Demiliani

Yesterday Microsoft has officially presented the Business Central Universal Code initiative (http://aka.ms/BCUniversalcode). For more details about this initiative, I suggest to read Waldo’s post here or my old post on Simplanova’s blog here.

In summary, with this new offering, selling what is called “non-universal code” (alias extensions not targeted to work online) to new Business Central on-premise customers might require to license two additional modules from 2022 onwards (names of these modules are subject to change):

  • Module “Implemented code is not in extensions”: if implemented partner code includes base application modifications, this module must be licensed.
  • Module “Implemented code is not cloud-optimized”: if the implemented extensions have target = OnPrem, this module must be licensed.

The non-universal code fees have a per full user (Premium or Essential) price with a per-year fee starting from 2023.

The announced timeline is the following:

Ursprünglichen Post anzeigen 809 weitere Wörter