Forum Discussion
Need Help
I have the table below: and I need to generate a new table where I define the value of line 1 and the others are searched in the column 'Prox Ponto', below an example Result ...
hello v-kelly-msft , thanks for helping me!
Attached the calculation in excel and the data source, some (Prox Ponto) may be blank, it's ok.
https://drive.google.com/drive/folders/17RlVn6JdcOPzjKz2Ed0FxXMvY07cl9Cn?usp=sharing
Hi Gabriel_Largura ,
Try the function "intersect",see below:
https://docs.microsoft.com/en-us/dax/intersect-function-dax
I have created a calculated table in attachment.Check for details.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!