New Column With Switch Statement Errors
I have this Switch Statement that I put in a measure and it works fine in the measure for showing the results of "Low", Med", High". But I wanted to use the same formula in a column so that I could use it in a slicer and I'm getting this error when I select it to add to the visual. "The column week number specified in the 'SUMMARIZE' function was not found in the input table. ??? I don't have any Summarize function. Makes no sense. Any ideas? GACategory = SWITCH( TRUE(), [Gross Adds]<=45,"Low", [Gross Adds]>=45 || [Gross Adds]<=70,"Mid", [Gross Adds]>70, "High" )
Calculate in measure at column won't filter other objects
Hi! I placed this measure in "values" on a Matrix: measure = CALCULATE(sum(Fact[Totalsum]),Fact[type] = "D") But when i select anything within this matrix it will filter all objects from the model excluding Fact[type] = "D" and showing the absolute total (Measure total is selected) I also tried using SumX but didn't work: measure = SUMX(FILTER(Fact,Fact[type] = "D"),Fact[Totalsum]) Why could this be?Calculating Total of a column inside virtual table
Greetings everyone, I have virtual table that looks like this: Each row is a product that belong to same product family (data is only partially visible here). "Revenue" and "Total Regional List" Price exist in the main Data Table. Next calculateions are virtual, used as measures. 1) I have first calculated total Revenue for this family, which is 858.317,55. 2) Next i have calculated "Level Factor Weight" for each item, which is "Revenue" / "Sales Revenue per Year by Family". 3) And finally i have calculated "Weighted Target List Price", which is "Total Regional List Price" * "Level Factor Weight". So far so good. Now i would like to calculated total or sum of "Weighted Target List Price", basically 0,06 + 0,03 + 0,00 + 0,65... (just as one see the numbers inside this table) and that is where i have problems. When i put "Total Regional List Price" and "Weighted Target List Price" in one virtual table without product numbers, they show the same result. Any hint would be very appreciated. Sincerely, PavloNew column to show shipping status query
Hi, I am trying to create a new column which would indicate when a Part Number has appeared in my dataset for the very first time, for it/them to labelled as "New", In the same column I want it to also indicate if the same Part Number is appearing in multiple weeks post it/them being identified as "New" that they are then reported and labelled as "Backlog", until they no longer appear so they are shipped which I've explained below. Lastly in the same or new column I also need it to indicate if the same Part Number hasn't appeared in the latest reported date dataset but was in the previous reported date dataset then for it to be labelled as "Shipped" and its very important that the "Shipped" Part Numbers value when I create a matrix table is allocated to that weeks reported date not to the previous reported date. Please see below for clarification.DAX Measure to concatenate common values found in more columns
Hi Community, I'm working with a table structured as follows: I would like to write a DAX measure that returns in any row a unique string of combination of Column_1 and Column_2 values that belongs to both columns. For example, if I put a slicer selector on Blue, the visual should return the following: Values "200" and "450" are not part of the concatenation because they only appear on Column_2. And, if I turn the slicer on Yellow, it shall return: Again, values "200" and "450" in Column_2 do not become part of the Concatenation, since are not common to both columns. In other words, I'm trying to figure out how to write a measure that repeat the same combination in any row of the row context [regardless the row] and is filtered by the field context based on Column_3. I do appreciate your kind suggestions! Marco.How to progressively count values in a column
Hi All After some help with the sample data i have below, i have a column called Reference and want to add a new column which counts how many occurences cumulatively within the data, for example '1472321-2860846' shows up 3 times in the reference column so what i would like is for Power Bi to show that it occurs 3 times but show the 1st instance, 2nd Instance and 3rd Instance if that makes sense, have done a bit of googling and searching this forum but so far havent found a solution Hoping this communintiy can help Thanks in advanced Ash
Issue with availability of incidents
Goodafternoon, I have 3 tables in my powerBi report; Calldate Enddate Unique ID Some of the calldates are 17 november 2022 where the enddate is 5 January 2023. I want the availability of December 2022 if i try to give me the hours i should get 728 hours offline but i don't know how to do this in my report. I have mulitple Unique ID's and multiple dates some are 5 December 2022 until 10 December 2022. Thank for your help, Kind regards,How to create columns that SUM based off other columns? HELP!
I am stuck. I don't think it is too hard, but need a push to solve in Power BI/Query. In excel I would use an IF statement on the pivoted data, but this is a large dataset and needs to split/assign values like the below yellow boxes. for “TERM”, it would sum the other pay. Is this possible in Power BI?
