Start from second row in column
Hi, I need to calculate theta angle in Power BI. Like in Excel: First row needs to be zero and the rest rows goes: 5163 needs to by dynamic based on data so i choose to get MAX value from added Index row in Power Query So first row in power BI needs to be 0 and the rest needs to be based on previous value I got 3 problems because: 1) I dont know how to set first value to 0 when I try to add new column 2) I cant use the function Earlier because in the first row it tries to get data from non existing row 3) Can you actually start function to work from second row ?
DAX help check for duplicates
Hi, thanks in advance for any help, we have the following requirements: I've tried a few different methods to pull this together but all hit a memory issue, any suggestions on the best approach/script? To identify duplicate clients based on email address: 1. For clients creating a new case in September, using email address how many have a different case same month 2. For clients creating a new case in September, using email address how many have a different case previous month(s) Fields: CaseSurrogateKey, Email, InteractionDate, FirstSessionYN Check if the email address exists previously but with a different case Example: Bob flagged as a duplicate client (based on email) with a new case same month Ted flagged as a duplicate client (based on email) with a new case different month(s) - as has a case in Jul and Aug already
