I am trying to roll up a table in DAX as seen below. It's just some operations. I can do this in SQL with joins or in Power Query with merges or pivots, however
I don't think this is doing what I want it to do. I have a fact table with columns date, weekstarting, customer, product and qtyshipped and I want an average pr
I have spent hours trying to solve and I dont' even know what to search an answer for: This is my base data table in Power BI PA PA FTE PERSON PERSON FTE Anne
I'm trying to use search in a description to see if there is an exact match to the field in another table. I used the code from How to search a row for a subst
i have the following dax formula i need this formulas value to be divided to 20. As is the formula works good, i couldn't figure out to add in division to it. I
I am having a problem displaying a sum value in a gauge visual. My table has many rows with a value in each along with a date. I wrote a measure that calculat
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.