Power BI

It’s a wrap! The Microsoft Data Insights Summit is officially over but that doesn’t mean that we cannot continue enjoying the amazing content, sessions, and community activities that happened between Monday and Tuesday. Let’s try to summarize the day again (even if we can’t do it justice).

I am trying to filter for roles using two tables that are both hierarchies. My issue is that I need them to perform an 'or' function and not an 'and' function.    For example, say I had a sales org and a location hierarchy. I would like to see all of John Doe's sales and all of Canada's sales. I can...

I am trying to create a filter for Row Level Security to check if the team contains the value "HR". We have multiple HR teams, so to ensure I capture all HR teams, I wanted to write a DAX script to say contains.   At present I can do this on a single team using the DAX below-   [Team]"ME HR Shared...

Hi Xiaoxin Sheng,   Wonrdefull, but this is static, the calculated table is 'created' when loading the data and doesn't change when filtering is applied. But I will give it a try based on your DAX formulas ..

The Microsoft Data Insights Summit finished today, and the videos of the sessions have already (!!) been published online here: I can’t remember ever attending a conference where there was so much …

Hi community,   I am quite new in Power BI and DAX. Currently I generated a table that shows in which month, which api has which exception and the total count for that exception. A typical data is like this:    April , user/getresource, SystemException, 4000.    So there are 4 columns, month, api, e...

I am trying to compare management fees against an account’s assets under management (AUM). In the data model, the AUM values reflect the market value of an account as of the last day in the month. The fees are what the firm is paid. The fees and AUM are two fields in the same fact table.   I am tryi...

Hi,   I am looking for a tip on how to solve this. As far as I can tell I will need some DAX magic.   I have two tables: Samples and Quality.   Samples have a unique ID field and two numeric fields for two analytical parameters. Quality has an ID field and two numeric fields for each of the analytic...

BOM Costing: How to evaluate the total costs of components and its sub-components within a BOM. Per item and also for any given sales quantity.

ArcGIS Maps for Power BI Home page.

In collaboration with Esri, a leader in the geographic information systems (GIS) industry, we're excited to announce that ArcGIS Maps for Power BI has reached general availability (GA).

Wow! What a day we had yesterday at the Washington State Convention Center. It was a day full of fun, learning, and networking. Let’s take a quick look at what happened (assuming that is even possible to do in one blog post) and get ready for today.

Obviously the big news of the day is the announcement for general availability of Power BI Premium! And if you were at or you watched the Microsoft Data Insights Summit you saw that announcement. B…

HI, im trying to get the STDev of a sumarized table, I tried the measure in the photo, It gives me the number Im looking for, but I cant display it in the Graph. I need to apply filters on it, thats why I cant create a real table.   PD: The real table is in the right side.

Hello,   For a table that shows values per week, I would like to add a column with the values of the previous week, so I can calculate a week-on-week change, and eventually a count of wins (positive changes) and losses (negative changes).  I wanted to use a DAX formula with PARALLELPERIOD.  However ...

Hi guys,   I understood how a moving average can be created by reading up on the forums. But I need a moving average of a percentage measure which I have created. The percentage measure basically calculates the tickets that were solved on time against the total tickets in the month, to give us a...

Hello guys,   I wanted to calculate the median in Power BI. We have a lot of rows full of data about the days we needed for a repair. In a different column we have listed in which workshop the repair was done and what kind of repair it was. So in Power BI Desktop I filtered one workshop and showed i...

Hello, I searched for quite a while and couldn't find a post close enough to my topic.   I have a fact table that has Forecast and shipments.  I am trying to create a report that would show by month actual shipments for the previous month and then pull in forecast units for the rest of the year by m...

Hi Everyone, I'm really new to DAX and have been struggling to come up with a solution to sum up latest 8 weeks data for each row. I've been trying filter function but it doesn't work.    I've simplified my ataset below, it has 3 columns: Week ending date | 8 weeks ago date | count 10/03/2017  13/01...

Hi All,   I want previous week sales anyone can send me DAX query.   Thanks

Our June release is full of new reporting features, new data connectors, accessibility features, and more. A few highlights of the June release are the addition of data bars to tables and matrices, markers for line charts, new map themes, and a horizontal image slicer. In addition, we are continuing to improve the “Add Column from Example” feature in the Query Editor.

-Posted by Rob Collie   OK, I was sitting at the 2nd-day keynote down in New Orleans last month, watching Amir Netz do a demo on some PowerPivot goodi

Power Pivot Performance Gotchas! All the common reasons I see for slower models and workbooks when consulting with my clients!

Watch the table-relationships of your Power BI or Power Pivot model in Pivot-view to see at a glance on which fields they are connected to each other.

It’s downing a bit slowly on me how awesome the direct retrieval of DMVs in PowerBI and PowerQuery actually is. Just see how easy we can build a cool view (…) Read more