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
I have one query can somebody please tell how to show Latest date in a date format So basically, I want to show the latest date selected by default and if the u
My Sales per Month visual looks like the first part of the picture. To show the running total of transactions I use this Measure: Sum Sales Running Total = C
I have a tableau measure which goes like this: ColumnA= IF [Rating Projection Year 1] = 2021 THEN SUM([Weights Ly]*[Next year rating predicted (1)]*[Inclusion F
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