I have been using Tableau for quite some time but am getting some new experience with Power BI and the use of DAX, and am wondering how I would go about recreat
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
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 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
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]),
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 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 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'd like to summarize the following ID's with it's prices on a distinct bases. So that means for the ID 123 both prices get summarize cause they are different.
I have two tables, Table A contains an attribute (ID1) and Time (date/time format). Table B contains an attribute (ID2) and two time columns Time_start and Time
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 have a table with multiple columns. One of these is 'EAN'. In this column there are supposed to be unique values. Unfortunatly this is not the case. Now I wan
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 am not experienced with DAX, but want to create a duration curve in Power BI which is responsive to the user's selections (slicers): I am working with time s
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