User Profile
pr1ngl3
Regular Visitor
Joined 3 years ago
User Widgets
Contributions
Copy data assistant stuck at spinning icon
Hi, I am trying to use the copy data assistant to build a pipeline to copy across a SQL DB. When selecting the 'copy data assistant' option, it just sits at a loading type screen with a spinning icon as per the below. It never finishes or errors out, just sits there. Does anyone have any ideas?Calculate calculated fields by row
Afternoon - hoping someone can put me out of my misery.... Using the above as an example... The following Tables have a relationship via a Customer Mapping table Term is a calculated column from Contracts (basic datediff from Today() to term end date, in months) GL has a calculated column to determine the last posting date of an invoice LastPostingDate = calculate(max(GL[Posting Date (bins)]),ALLEXCEPT(GL,GL[Customer Map]), GL[Posting Date] <= today()) Last Invoice is a measure to sum the value, filtering so the posting date is the same as the last posting date LastInvoice = calculate(sum(GL[Amount]),filter(GL,GL[Posting Date (bins)] = GL[LastPostingDate])) Remaining Revenue is a measure to multiply the 2 values Remaining Revenue = calculate([LastInvoice] * MAX('Contracts'[Months Remaining])) All this is working accurately per line (by customer) however, the Total (as expected) is also calulating in this was, summing the Last Invoice and multiplying by the MAX of the term remaining. - highlighted in RED. Whereas, I need to calculate each line individually and sum that, highlighted in Green. Any ideas? Thanks in advance
