Forum Discussion
Removing duplicate rows, data from different (joined) data sources
...or I have to build a named TABLE out of at least three database joins, filter it down and then jump over to the report view to finish the summary. Parking it for tonight - shouldn't be doing work today anyway 🙂
AllisonKennedy Greetings to NZ from Tier 3 in the UK (can we have your PM please?).
Another few hours, got one of the earlier attempst working but it was inserting 0's and 1's randomly - I guess as there are other orders in my data source that my view had filtered out. So have gone back and tried to put the filter on the component FreeTextInvoiceHeaders and FreeTextinvoiceLines, but hit the wall again, can't get any measure nor column using the suggestions to get added.
I've also tried to use the text.buffer and text.sort combinations on the data sources without success.
Even got stuck trying to do a MID of a string to extract two characters following a certain word, so probably need to walk away from the screen and let my head unjumble.
I'm going do to some Power BI training over xmas (I have used a certain other product from the Seattle area for 8 years, so just going through a period of rough adjustment to this products nuances). Just need to sort the view by customer and invoice date descending, then trim off all but the 1st row displayed for each customer. Currently proving a bit of a struggle 🙂
Hi,
Could you share some data and also show the expected result.