Search results

Hi everyone. Thanks for the support. I also posted this question in stackoverflow and I got a answer there. Take a look. https://stackoverflow.com/questions/78082499/recursive-lambda-to-join-full-parent-child-hierarchy

Hey Monty. The suggestion didn't work. Take a look below. Also, it took some seconds to calculate it. I don't know if it was time/process consuming due to the errorm or if this solution is really tuff .

Hi. I'd like a result like last column in the picture (Full Hierarchy). I can do that creating multiple support columns. But I'm almost sure that it's possible to do that using recursive lambda. I made some tentatives, but no success. Can anyone help on that? Tks! col A = child info col B -...

Hi! Coping the simulation question: "Based on Extract-date mar02nd, What happens to my volume of demand if we postpone 30 days all the orders for customer code 6 ?" Columns: EXTRACT_DATE - date that all data was extracted from ERP Customer_Group - self explained Customer_Code - code of the...

Hi, I'm new in POWER BI and need help to create a simulation. I have a table with demand information. With historical "pictures". In the example below I've extracted a info in day feb 17th, and other picture in feb 20th. So in each Extract_Date we can have multiples orders for many different...

Tks a lot, Peter! Elegant solution. It's amazing what we can do with excel. See you.

hi everyone. I've searched something similar in forum to avoid repeated questions, but I didn't find it. Sorry if it's repeated. I have a specific range pattern that I'd like to repeat it every time a occurrence appear. Look at the file. We have 3 regions: - the pattern I'd like to replicate -...

Hi , I'm Marcelo, from Brazil. I follow you for years. I already learned a lot here. Your site and work is a reference point to me. Tks a lot!