I have created a date table in Power BI called DimDate with fields, Date, Month (Month Name in Text Format), MonthNum (Month in numeric), MonthSort (Redundant f
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'd like to make a visual with average amount (totalled per one or more teams) per month (while keeping date hierachy to show data per day). I have a table with
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