Forum

Ok, great, we made 1 baby step forward. Question 2: do you want to see only current day compared to previous file? Or you want to store all previou...

Sorry, still wrong answer. I understand that they dissapear. The question is not WHY they dissapear, the question is HOW? That row is simply ERASED...

I understand that there are 3 situations. My question was very specific, for one situation, to understand how that situation is handled, they just "di...

I don't understand your process to be able to help. Your first table is just a list of names, codes and dates. How do you define records that co...

Hi Stefano, In Nuove query you have this: = Table.NestedJoin(#"Giacenti Precedenti", {"Code"}, Giacenti, {"Code"}, "Giacenti", JoinKind.RightAnt...

It's the term value converted to a number that can be used in calculations and comparisons (MAX, <>)

Hi Wico, A while ago, found a very interesting solution, that opens another hidden gate for Power Query. Seems that we can use the power of Java...

Hi Stefano, Can you describe the process? What steps needs to be made in your files to achieve what you're after and what does not work?

Hi Cheryl, Please take a look at the attached file and let me know if this is what you're after.

In Power Query, add a new column with this formula: if Text.Contains([Name],"PARENT") then [Name] else null Then select the new column and use t...

Hi Mansoor, Please provide a sample file so we can see your data structure, it's hard to follow your description. If you prefer a generic soluti...

Hi Vivian, There may be restrictions applied by the web server for incoming connections. On first attempt, the query completed fast, no errors. ...

Hi Cheryl, Is it possible to have more than 1 term value at the same date? In this case, a measure will return more than 1 value for the latest dat...

You're welcome, Glad to hear you're happy with the solution, thank you for your feedback 🙂

Hi Percy, Steps: 1. Grouping by Parent and Child, return All Rows (no aggregation) 2. Add a new column with AddIndexColumn formula, referring...