I'm attempting to calculate market share (percentage of total) for a segment after a user selects a specific product within a filter. Data looks like this: Dat
Has anybody got Podio to work with Power BI. I managed to get the token process to work in Power BI. I can get single record results to work but when using a li
It's my first time using this website, and I am a newbie with PowerBi, so apologies in advance if the question isn't clear. This is a quickly reproduced scenari
I have a specific hierarchy that I have developed: I was expecting it to be: level 6 ( )level11 ( )( )Account description level 3 ( )Account description But I
I have a table that lists a series of dates and a sales amount made on each date. So against each date, I would like to create two additional columns a)A curren
I need a little help since im new to PowerBI. I have a data set which says what have been eaten in a specific day. At the end there are columns which show if th
I have a tricky situation in Microsoft Power BI, and DAX language: I am developing a new Calculated Column called Status_CC in a table called Customers; we refe
Working on a stacked bar chart with PowerBi desktop up to 53 levels. Sometimes fewer levels, sometime more. Need to assign a color that is the same irrespecti
How to return DAX table based on a condition? The IF function cannot return a table in DAX. IF( 1=1, table_1, table_2 ) It raises an error: The expression refe
I made a measure that is as follows: wo = CALCULATE( DISTINCTCOUNT('Table1'[won]), ALLEXCEPT(Table1, 'Table1'[flag]), ALLEXCEPT(Calendar,Calendar[End of Week]),
is it possible to compare particular values from a table/report from power bi data set with another table from excel sheet? In the power bi data set i have the
I have dates like: I need to do two transformations: Convert it into datetime field date and time in the initial data shows in GMT. Necessary translate into ou
I am using Azure Logic App workflows to refresh a Power BI dataset every 5 minutes. The workflow was working for several weeks without any issues . But since la
I have the following two tables in excel. Table 1 contains the date, closing share price and log. In the second table, i have the date and the number of years
Getting this error when using Get Data with PowerBI Desktop to connect to SQL database Microsoft SQL: The ORDER BY clause is invalid in views, inline functions,
I am creating a family tree using a Hierarchy Chart by Akvelon. I have added one table under the chart to present the people's data. When I select any node it w
I am requested to provide the following information from a Teams Channels: Who used a specific mention/tag example @support and how many times(total tags by eac
I have order table like CustomerId OrderAmount Orderdatetime OrderAmountCurrency AAA 120 02/03/2022 02:03 US$120 AAA 20 02/03/2022 02:20 US$20 AAA 320
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
In Microsoft Excel I am considering columns and cells to make specific sums in a calculated column, here's an image as an example where the column "G" is where