I know that there are various questions related to looking up values in power bi. However, my question is related to looking up multiple values based on conditi
I made a measure that is as follows: wo = CALCULATE( DISTINCTCOUNT('Table1'[won]), ALLEXCEPT(Table1, 'Table1'[flag]), ALLEXCEPT(Calendar,Calendar[End of Week]),
I have these two tables. Both tables have a relationship by id (one to many) TableA id 1 2 3 TableB (date field is a date/time datatype) id date 1 1/0
I have a online Powerbi dashboard. I want to create a cvs which contains a visual summary of all the objects in my dashboard. This is what the export will look
I need help with Power BI. I need to create a meausure to incorporate in the TABLE visualization (which varies according to the filter from the table DATE) so t
I am currently working on a power bi dashboard that uses an excel file as a data source. I want to auto populate the excel file with new values from existing ex
I have a PowerBI report that uses both a Web URL and SQL Server data. The Web URL only returns 100 rows per page, so I followed this tutorial to loop through t
I am new in Powerbi. I have requirement to download tiles using powerbi api. tiles reside at below url. https://app.powerbi.com/groups/me/apps/{appid}/reports/{
I am creating a calculated column in Power BI using multiple if and Lookupvalue functions, using Lookupvalue function to return "Yes" if SKU exits in Spare SKU
I have written a python library (ak_sql.py) to query my sql server and written another ".py" script (query_sql.py) to invoke this library and return data in dat
Table 1: Table 2: Result: I have tried using Fuzzy matching but it's not giving me the results. Please help!
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
I am trying to come up with the right strategy on BI Testing (UAT/Regression). Below are the details. Appreciate if you could share you point of view please? Te
I concatenated four columns using this code (to prevent null values to be linked together) in Power Query (Power BI Desktop): = Text.Combine(List.Select( { [Col
I have to sort month name from January to December in Power BI Desktop. Power BI sorts the column according to the alphabetical order. Here is my dataset: When
[Please refer to the below image. I want to create a stacked column chart but I don't have a column that includes 0-30, 30-60, 60-90, etc. How did I put this ra