I have been working with SAP data source lately. And in SAP dimensions, parent-child hierarchy is very common and there is a need to flatten it in Power BI. A common parent child hierarchy is an employee table. The employee table has a manager column that determines the hierarchy. E.g We want to flatten the
Category: Tutorial
Once you create a PowerApp, you need the capability to share the app with users. How do we do that ? Let’s take a look. To share a PowerApp, the app has to be saved in the cloud. Local apps cannot be shared. If you are using PowerApps studio, click on File -> Share. This will
When a user navigates from screen 1 to the screen 2, we want to render content on screen 2 based on the user’s selection on the screen 1. To do this we have to pass the selected value(s) to screen 2. Let’s check out how to achieve this in PowerApps. Download the sample App from here. In the
An app typically has more than one screen and we need the capability to navigate it. PowerApps has two functions, Navigate and Back that helps with navigation. Let’s check out how these functions work. Download the App from here. Select Next button on the WOD screen. From the properties section pick OnSelect. Notice the formula: Navigate(WODDetails,ScreenTransition.Fade) Here is what
Traditionally, when we do variance analysis, we compare the actual value of the metric being measured to its target value in either absolute or relative terms. For example, if I were to compare current year sales (Sales CY) to prior year sales (Sales PY) I might want to create a Sales YoY calculation as well
I am on a CrossFit high, with the Open just concluded and Regionals about to begin… So I am going to use some of my favorite Hero work outs (WOD) as a sample for this tutorial. There are scenarios where we want to display content based on the user’s selection. Here is how to do it.
It’s been almost two years since I posted about the CONCATENATEX() DAX function here. At the end of that post I promised to publish a tutorial on how one might do Market Basket analysis using this function in Power BI. Well, I try to deliver on my promises even though it might take me
Today I connected to SAP BW using the connector available in Power BI Desktop. Following link does a good job explaining the steps: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-sap-bw-connector/ Ran into a road block while installing SAP Netweaver RFC SDK library. With the help of bases team I downloaded SAP Netweaver SDK library. However there is no explanation as to where/how this
Here is how to get PowerApps Common Data Service Connector working. Note: You need to have Admin rights to Enable Power BI Integration Login to https://web.powerapps.com On the top right corner click on Settings (gear icon) Select Admin Center Select the environment you want to enable Select Database from the top menu Select Enable Now we
Here is a common requirement that I have come across: “I want the Date slicer to automatically select current date without me having to manually change the slicer”. Here is a way to do that. We have a Power BI Desktop report that was created on April 10th 2016. When the report was created, we
