I created a DB that combines data from multiple views into 1 view for me to pull into PowerBi. I use Power Query to append the views into 1 table for me to pull from and create my visuals. The problem is the DB is growing much larger then originally planned and my computer is have a very rough time
Tag: powerbi
Compare Between two value in different UOM
I try to build Report on Power Bi to show the comparison between Sales achieved per items and Targets per items but the sales in many UOM and the Target in one UOM How can i do it ? Answer The usual approach is: define a Item_UOM table which lists all possible UOMs for each Item, with a conversion factor
SELECT … WHERE Query in DAX
I have a SQL query: I want to rewrite it with DAX, but it isn’t working. Here is what I have now: How would I create a similar query with DAX? Answer The SQL predicate that is used here translates to starts with ds. Example The exact DAX equivalent Measure would be Internally FILTER ( VALUES ( ‘Table'[doc] ), LEFT
How to convert SQL statement to Power BI DAX?
I have no idea how to recreate the following code from SQL to DAX in Power BI: Or perhaps there is a way to operate on SQL commands in Power BI with imported and filtered tables? I want to do the SQL query on the already sliced data in Power BI. Thank you in advance 🙂 Answer You can achieve
How can I create an Index column based on 2 columns (time and the process level)
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
Power BI Report Builder Indicator Formula
I am adding in an indicator to a PBI Report Builder Report. The indicator is based off multiple fields from the dataset so I need to use a formula, to create the three up/down/side arrows. Previously in Crystal Reports this could be implemented using a series of IF statements as follows. The below example is what is required for the
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
Power BI DAX – find repeatability
Given data as such: Is there a way to make a measure that would find if for each month, last three Values were True? So the output would be (F,F,T,F)? That would propably mean that my actual problem is solvable, which is finding from: the count of those booleans for each row, so the output would be (0,0,2[A and C],1[B])
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