With the Power BI cross-report drillthrough feature, you can contextually jump from one report to another report in the same Power BI service workspace or app. You can use cross-report drillthrough to connect two or more reports that have related content, and to pass filter context along with the cross-report connection. To initiate cross-report drillthrough, you select Read More
How to Count Unique Values in Excel 365 – UNIQUE Function
The Excel UNIQUE function returns a list of unique values in a list or range. Values can be text, numbers, dates, times, etc. Extract unique values from range Return value Array of unique values Syntax =UNIQUE (array, [by_col], [exactly_once])Arguments array – Range or array from which to extract unique values. by_col – [optional] How to compare and extract. By Read More
How to Protect Power Queries in Excel?
Following are the STEPS ; We take advantage of Protection Structure in Excel. This is where the magic begins, follow carefully: 1. Stay in the Excel File and go to Review TabNote: (Excel and not Power Query) 2. Choose Protect Workbook 3. Ensure the Structure box is ticked 4. Provide a Password (optional) 5. Confirm by re-entering ( if password is Read More
How to Refresh Data Connections in Excel VBA
Quick reference: The first one will “refresh” only one file. The second will “refresh” all open excel files. ThisWorkbook.RefreshAllActiveWorkbook.RefreshAll With the release of integrated stock pricing in Microsoft Excel, it was unfortunate there wasn’t any sort of setting that allowed for automatic updating of the stock data while the file was open. Even worse, there Read More
How to Count Unique Values in Excel – With COUNTIF
This example shows you how to create an array formula that counts unique values. 1. We use the COUNTIF function. For example, to count the number of 5’s, use the following function. 2. To count the unique values (don’t be overwhelmed), we add the SUM function, 1/, and replace 5 with A1:A6. 3. Finish by pressing CTRL Read More
How to Set up Cross-Report Drillthrough in Power BI
With the Power BI cross-report drillthrough feature, you can contextually jump from one report to another report in the same Power BI service workspace or app. You can use cross-report drillthrough to connect two or more reports that have related content, and to pass filter context along with the cross-report connection. To initiate cross-report drillthrough, you select Read More