Getting a value to appear on multiple lines
I am trying to write SQL code to get a value that appears on one row to appear on all rows that contain a similar value. Below I have an example of what I currently have but need a way to get the “Batch Status” column to match for all rows under the same Batch ID
Add query parameter from GUI to Power BI direct query
My database contains data for different business-dates and getting all data for all business dates would not be feasible for Power BI. Luckily, I only need the data for a given day.
Converting char to date and pulling past two years data
I need to pull data from tables with millions of rows and limit it to just the past two years. I am working on developing a SQL statement to enter into Power BI to limit what it pulls. Obviously I am a novice but I cannot figure this out and all suggested approaches are not working for me. It is also unclear to me how to convert, limit, and pull all of the data from this table.
SQL Query for to compare each row with other column values and if yes print other column name
Input:
Improve terrible PowerBI loading times
I have the following PowerBI setup and experience terrible loading times (usually run into the request too large error) and look for ways to improve the user experience
Power BI dynamic filtering
I have processdata in an SQL table containing values:
datetime, tag_name, tag_value, tag_id etc.