I have a PowerBi report with several data sources, SQL query and Excel connector. The SQL data data on our Products whereas the Excel is living data on salesper
Table 1: Table 2: Result: I have tried using Fuzzy matching but it's not giving me the results. Please help!
I am working on SSAS Tabular project and I am using Live Connection when importing data to Power BI. Do I need to schedule refresh in Power BI ?
I have a call dataset. Looks like this If a call about a certain member comes in within 30 days of an "original call", that call is considered a callback. I ne
I'm using Power BI Dataflows to access spreadsheets I have in blob storage. I have configured IAM permissions on the storage account for myself and the Power BI
I'd like to connect to a power BI database and query it using SQL. My first instinct was to use Python's pyodbc package, like so: conn = pyodbc.connect( 'DRIVER
I am trying to calculate the total recipe cost price for each recipe. I used the below DAX formula as shown in the image but I am not getting the correct result
I am doing a DAX query able to retrieve a list of products installed before a certain date (COIDate) , and that have a specific ProductLine. But, it returns t
I am trying to add a service account key file to access a bigquery data set in power bi. I am selecting service account login during the set up process. I added
I am having an issue using the Distinctcount function in DAX. I have a table with a total of 1,154,493 rows. I have a measure created to count the number of d
My test tabe in powerbi: IdRecord Date Value 1 2022-04-25 23:45:00.000 100 1 2022-04-24 18:07:00.000 344 2 2022-05-01 23:45:00.000 5 2 2022-05-02 18:07:00.000
Quick Note, I have reviewed these threads and they do not fix my issue: ( Outdated info, see documentation below ) Access Snowflake query results through PowerB
How to assign automatically st/nd/rd/th to number behind in date field using power bi DAX formula. I'm creating labels for date something like this 1st MAY 202
I'm getting this issue when trying to load/refresh the report, When I clicked the continue the loading wizard starts with an unending state. I am receiving the
How to download the report as an excel in the PowerBI. Currently, I have embedded the report in the SharePoint page using the PowerBi web part, would need to do
Hi I have two tables(table1 & table2) which both contain year, quarter, month and week. I want to apply a slicer such that when I change the year or Quarter
I have three different tables. I want to select different columns from each of the tables and create one table based on some filters. Have a look at the followi
I have some data about projects I would like to transform in a way that makes it easier to analyse with PowerBi. The data looks like this: Project Number Proje
I have a column with "Yes" or "No" values in it and I want to count the number of rows with "yes". I can create a new column and have values =1 or 0 depending o
I have a problem with the MTD column. I want this column to show only April '22 sales and not the previous months. For example, the sales for April '22 is 7379,