A few DAX functions

Data Warehousing, BI and Data Science

This query shows summarise, addcolumns, filter, union, row and format DAX functions:

  • The financials table is filtered on Product = Montana
  • Display just the Country column using Summarize
  • Sales column is added using AddColumns functions
  • Total row is added using Union function
  • Add commas for thousand separator using Format function

Canada 24,887,655
Germany 23,505,341
France 24,354,172
Mexico 20,949,352
USA 25,029,830
Total 118,726,350

Data source: link
Ref: Whytheq: link, SQLBI: link

Ursprünglichen Post anzeigen

Microsoft PowerApps Office Add-In enables user to read, modify and insert data in CDS environment. Add-In is available for download here for free, or you will be prompted to install Add-In for first time when you open entity data in excel from PowerApps portal. Add-In establishes connection to PowerApps OData service. Note: Add-In is compatible […]

über Manage CDS Entity Data – Microsoft PowerApps Office Add-In — Bansal Blogs – Dynamics 365, PowerApps, Microsoft Flows, Power BI

Calling The Power BI REST API From Microsoft Flow, Part 3: Finding All Data Sources Used In A Power BI Tenant

Chris Webb's BI Blog

[Part 1 of this series can be found here and part 2 here]

The problem with self-service BI is that you never quite know what your users are up to. For example, what data sources are they using? Are there hundreds of Excel files being used as data sources for reports that you don’t know about? If so, where are they? Could they and should they be replaced by a database or something else more robust? In this post I’ll show you how you can use Microsoft Flow and the Power BI REST API (see part 1 to find out how to create a Flow custom connector to call the Power BI API) to get the details of all the data sources used in all of the workspaces of your Power BI tenant.

I’ll admit that doing this turned out to be a bit trickier than I had expected…

Ursprünglichen Post anzeigen 717 weitere Wörter

Keeping Big Data Big with Aggregations


I have built several solutions over the years to enable business users to get at the data they need to do the analysis that is important to them. I would build cubes so that they could slice, dice and mold the data into the shape they need. They would use tools like Excel, Reporting Services and more recently Power BI to interactively work with an entire dataset. Then I entered the world of Big Data when I started building reporting solutions Microsoft’s Bing business teams. All the sudden, the data was too large to fit into one cube. Suddenly it became impractical to have to load all the data into one SQL databases.

While the size of the data presented many implementation challenges to the development team, it didn’t change what the business users needed to do with it. To enable them to use the same tools they were used…

Ursprünglichen Post anzeigen 939 weitere Wörter

Power BI Dataflows

Die vielen Neuerungen in Power BI sind ja für mich kaum noch alle nachzuverfolgen. Darum versuche ich, die Informationen zu filtern. Dataflows sind mir schon seit einiger Zeit im Hinterkopf hängen geblieben, da es hier mehr um Design als um Visualisierung geht. Eine wirklich erschöpfende und trotzdem flüssig zu lesende Abhandlung dieses Themas gibt es auf dieser Seite zu lesen.

Sehr gut und vielen Dank dem Author:







Microsoft Flow – Business process flows from a traditional Flow perspective


Recently Microsoft added Business process flows to their Microsoft Flow platform. If you thought that this was just like Flow then you will very quickly find out that it is not.

A bit of background first

As part of Dynamics 365 there is the Process Center.

Within the Process Center you can maintain processes within Dynamics 365.

By clicking on one of the process links you get to the process maintenance screen.

This is where you can add steps to your flow in Dynamics 365

For my Flow followers a quick overview of what this gives to us in Dynamics 365. In the below screenshot you can see the green section that shows the different stages in a process related to leads.

This green section is where users are guided to fill in certain bits of data. The matching process for the above lead is shown below. The 4 blue…

Ursprünglichen Post anzeigen 262 weitere Wörter

Dynamics 365 Business central on-premise: why I can’t find my C/AL page on Search?

Stefano Demiliani

This seems to be a problem for many partners and developers that have start working with Dynamics 365 Business Central on-premise in these days and this is not actually well documented in my opinion.

I think that you already know that when developing a page with the AL language extension for Dynamics 365 Business Central in the cloud, you need to set ApplicationArea and UsageCategory properties in order to see your page in Search.

If you open a Dynamics NAV 2018 page with CSIDE, you don’t have these properties available, while if you open the same page with Dynamics 365 Business Central on-premise, now you have them available:


What happens now is that if you create a new page in CSIDE with C/AL, set the ApplicationArea and UsageCategory properties and add that page to a Menusuite, often you can see the page in Windows Client search but not on…

Ursprünglichen Post anzeigen 132 weitere Wörter