Skip to content
Advertisement

Tag: powerbi

Multiple Views combined into 1 Table/View using UNION (SQL)

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

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

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])

Advertisement