I am trying to obtain the Index column (highlighted in yellow) that can count the number of times the product ID has iterated through 1 – 6 denoted by the Status Key and the tible is sorted in chronological order. For detail: The Product ID follows a chronological order denoted by the timestamp and the Status Key can fluctuate back
Tag: powerquery
Present URI in database as clickable link
I have a table in a SQL Server 2019 that stores URI’s like this: These values are stored as nvarchar. Is there a way to make these clickable? So that, when this table is for example read by PowerQuery users only have to click the link to open the file? It is assumed that only those filetypes are allowed for
How can you group data by multiple fields with separate totals in SQL or Power query
I have a set of data that I want to count by multiple characteristics. I am starting with something likes this (True/False for catagories) week PP SEN 1 T F 1 T T 1 F F 2 T F 2 T T 2 F F 2 F F 3 T F 3 F F I want to end up with
Passing date variable in Power Query to ODBC source
I have managed to extract a date from Excel (that the user can amend).[A named range called DateB]. I want to be able to pass that to a variable in the sql part of Power Query so that various checks can be made before passing the data back. However, I cannot get the variable @man_Date to accept the date that
Power BI – DAX List.Select syntax to return specific records
I unfortunately discovered today that I cannot use SQL to return a subset of records when Power BI references a SQL Server DB as a data source. I’m trying to do something similar to a SQL where clause using “IN” for example I’ve tried this (and several other variations) in DAX but get an error for Token Literal Expected: Is
How to combine rows with the same ID into a list
How can I make the below table like a list. I want the result to be like this Any ideas? Answer try the following, it may solve your problem. Let’s say your existing table name is yourTable and the new table to be created is groupedNames. in data view, click on new table and paste the following: