Search results

Without sample dataset and mockup of your desired result (created manually). It's hard to help you. I'd recommend uploading a sample workbook here.

Well, the issue is you are using comparison operation that expects single value, but using function that returns list of items. i.e. ALLSELECTED(). This returns list when more than 1 item is selected in your SKU. Personally, I'd just create relationship between your two tables using [Target...

You should flatten out the table. You will not get correct result when you try to filter multiple columns in value field. Load data to Power Query. Then Unpivot Date columns. I'd also recommend transforming date string to actual date value after that. Then load the result to data model and...

Without details, bit hard to help you. But in general, this can be caused when you have tables with relationship, but not all items are present on one side (i.e. on dimension side).

But you are opening the destination workbook in your code... At any rate, instead of using Application.GetOpenFilename, use Application.FileDialog(msoFileDialogFolderPicker). Then you can iterate over files using Dir function. You can find many sample codes in the forum. Ex: In Folder , 2 or...

Don't rely on implicit conversion for this type of date string. It does not contain year info and can cause various issues down the line. 2nd one causes issue, since it contains future dates. Implicit conversion will not know what to do with them. And looking at stats, 1st URL is for current...

My recommendation. Change how your data is stored. Merged range is nothing more than visual fluff, and it will cause all kinds of headache when you try to tranform, extract or analyze data. Never use merged range, unless it's the very last step to make it visually appealing.... Even then, I'd...

There are number of ways to deal with it. But easiest is to include in your Calendar dimension table, that calculates IsWorkingday (Boolean). Based on list of holidays and Date.DayOfWeek(). Then it's simple matter of counting rows where IsWorkingDay = True.

Ok took a quick look... You don't have anyone that participated in more than 2 consecutive round. Not sure how you want data visualized? Do you have an idea of what it should look like? All rounds show same number of participants... Don't really see the point of doing data visual for this...

Go through link. Import data from Excel to SQL - SQL Server | Microsoft Docs

I'm looking at your data and Round2 is different from all the others in it's structure. Is this intended?

I'd recommend uploading sample data in a workbook or zipped pbix file. Without it, bit difficult to help as we will need to manually recreate data to give you solution.

Oi, I'd strongly recommend separating out report layout for viewing (i.e. your schedule sheet), and data structure for input/storage. Data input (or storage) should always be done in flat table structure (i.e. Date, Shift, Hours, Dept, Employee, Week ending columns). This will make it so much...

When importing data, replace the current "Changed Type" step with your own. Select "Changed Type" step in Applied steps pane. Then in column click on data type icon. At bottom you should see "Using Locale...". Set data type to "Date" and use Locale English (United Kingdom). For source date...

Since you posted in Power Query/Power Pivot forum. I assume that you are using OLAP based pivot table. Data model is somewhat limited in formatting that can be applied. So in this case I'd recommend using PQ to add display value as well. While its possible to do in DAX measure, it's more...

So, from your export. You'd use PQ to combine data into single table. However, you need to differentiate each month's data. To do this, I'd recommend naming your table with Month name included. Ex: Tabel012021, Tabel022021 etc. That way you can query the workbook. Either using...

@Lucia A question, you need this as calculated column? Or as DAX measure? If in a measure, you can use SEARCH function. But do note that you need to ensure you add 4th argument for this to work. Otherwise, you will get null returned (i.e. error). CountPartialMatch:= CALCULATE ( COUNTROWS...

Hi welcome to the forum. As a new member, please read below. Site Rules - New Users - Please Read | Chandoo.org Excel Forums - Become Awesome in Excel As indicated, we ask that you follow below guideline when cross-posting. While reddit isn't forum per-se, it falls under same guideline.

Are you sure that "trending" is the info you want? The URL you supplied is for player stats. At any rate, meat of data is in leagueSeasonStats[statsData]

It's simple matter of text manipulation using Text.Split(). Once you have extracted out Json string part, use Json.Document to parse. However, you will need to do further exploring of data, as the data contains multiple lists/records that are used to link numeric ID with string value. let...

Not sure what your question is. Have a read of link. Exploring Azure SQL Data Warehouse with Power BI | Microsoft Power BI Blog | Microsoft Power BI Unless you specifically set up Data Warehouse yourself, there won't be any. Do you have Azure Data Warehouse set up?

There is dropdown menu when you click on the field that's added to value field of the visual. Note that this only works if field is added, not when DAX measure is added to the visual. FYI - There is no option to make MIN to be default selection. If that's what you are asking. I typically never...

If I recall Marco Russo has great book. The Definitive Guide to DAX For PQ... M is for (Data) Monkey by Ken Puls is well regarded. I've not really used books myself. But I read their blogs and they are good.

DAX measure can be done as following: Completed := VAR temp = SUMMARIZE ( Table2, [City], [Name], "PassCount", CALCULATE ( COUNTROWS ( Table2 ), FILTER ( Table2, [Test Status] = "Passed" ) ) ) VAR CountComplete = CALCULATE ( DISTINCTCOUNT ( [Name] )...

Each site has different structure and methods. You need to use your browser, and the developer tool in it, to study what requests are sent to the web service and what is returned. Identify the transaction that contains info you are after. Then you need to decipher how it is structured. Then...