Direct query - add values from other table to the main table with conditions
Hi, I have created model in "direct query" mode, I dont have experience with it. (I normaly use add Column with combination formulas Calculate + Allexept... now it doesnt work) I need to add values from one column in "table B" to the "table A" for Column xID. I have this conditions: max values from "Column Order" -1 for each Column xID determine value in Column Personal ID in Table A, which is key for connect to Table B. The unique key for this situation in Table A is combination Column xID with Column Personal ID (because values from Personal xID can be repeated). I need to add value from Table B - Column Name to the new Column in Table A (in need can by measure), duplicated for same Column xID values. (Table A has over 23 milions rows)
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" )
How to Capture Changes by Specific Filters
Hello I am fairly new to PowerBI and not sure if this is something I can do but I have a visual that I need to get the Net change by Month and Country. I have provided a photo below with the current visual. The goal is to create a new measure or column that would be able to show me either the sum of the values in the red or show the difference between the Starting Headcount and the Ending Headcount. The issue I am having is those values under USA and IND are values of column Roll on/ Roll Off and I am having trouble trying to distinguish them, I have tried using the Switch function but no success. Could anyone help point me in the right direction? Thank you.
Switch logic not pulling in column from another table
Hello, I am trying to adjust my Switch statemnt so that I do not have to tediously input vlaues when I have to update the dashboard. Above line "3" is my old logic. Line "5 " begins my new logic, where I am trying to say if the code = 1003, and the LOS O/E is < [P95] (which is coming from another table) then return "P95". Here is the [P95] column The error I get says "A single value for column "P95" cannot be determind. The relationbetween the tables are many to many (*:*) and being cross filtered in both directions.
Add column that will display the first / new load date that the row appeared
Hi Good Day, I have this table that shows ID, Load Date, Product # and Section. I want to add a column that will display the first load date that the row appeared, but if the row will not appear on the next load date (or will skip a date) and will apear again on the next-next load date, the date that must appear is the new load date. This is my desired output: I tried using this measure, Date Appeared = VAR firstload = Sheet1[Load Date] VAR mindate = CALCULATE(MIN(Sheet1[Load Date]), ALLEXCEPT((Sheet1), Sheet1[Product No], Sheet1[Section])) RETURN IF(Sheet1[Load Date] = CALCULATE(MIN(Sheet1[Load Date]), ALLEXCEPT((Sheet1), Sheet1[Product No], Sheet1[Section])), firstload, mindate) and I got this result, I find it hard to display the new load date. Hope that you help me with this. Thanks a lot..
