Calculate Days Of Zero Stock Background: I am building a supply chain dashboard at our company and a big problem we are having is STOCK OUTS. I have a table of over 5 million rows that contains all our SAP movement data inside inbound goods in and outbound issues to production. From here i have Read More
Category: Power BI
How to Sync Slicers on Different Pages
Suppose you want your report readers to be able to look at overall sales metrics, but also highlight performance for individual district managers and different time frames. You could create separate reports or comparative charts. You could add filters in the Filters pane. Or you could use slicers. Slicers are another way of filtering. They narrow Read More
How to Fix “on-premises gateway could not be reached” or Similar Errors
Troubleshooting dataflow issues: Connection to the data source When you create a dataflow, sometimes you get an error connecting to the data source. This error can be caused by the gateway, credentials, or other reasons. This article explains the most common connection errors and problems, and their resolution. Error: An on-premises data gateway is required Read More
How to Add or Remove a Gateway Data Source from Powerbi.com
We’ve split the on-premises data gateway docs into content that’s specific to Power BI and general content that applies to all services that the gateway supports. You’re currently in the Power BI content. To provide feedback on this article, or the overall gateway docs experience, scroll to the bottom of the article. Power BI supports many on-premises data sources, and Read More
How to Create a Measures Table (Placeholder for Measures) in Power BI
Creating a measures table in your Power BI data model is one of the most common questions we get from folks wondering how they can better organize the measures they create. When navigating through your data model in Power BI Desktop, it’s easy to get lost in a sea of tables and fields, especially if Read More
How to Compare Sales With Last Year on Day in Week in Power BI
A very normal calculation we do is to compare a value, for example, sales, against how we did last year. The easiest way to do this is by using the SAMEPERIODLASTYEAR function to create a measure that looks like this Sales LY = CALCULATE( [Sales] ,SAMEPERIODLASTYEAR(DimDate[Date]) ) As shown in the image above this works Read More