Use a table created with dax in power query

[CarmeloSanchez]

Hi everyone,

First of all thanks for reading me.

The problem is that I have calculated a table using dax (combining, joining and using lookupvalue and related with several tables) and now I need to send it back to power query in order to make a step with the calculated table. The step is to split de rows depending on the number of days (difference between start and end).

I think the only option is to use excel to obtain data from powerbi, create a dinamic table and in other page of the same sheet create a table that uses the values of the dinamic table, and then obain data from that excel.

Do you think there is any better opcion?

Thank you in advance.

PS: I would mark as solve with the best answer.

[amitchandak · Accepted solution]

@CarmeloSanchez , In power query you can use merge

Lookup in power query

https://community.powerbi.com/t5/Desktop/How-to-lookup-values-in-another-table-in-the-Query-Editor/t...

https://eriksvensen.wordpress.com/2019/02/28/powerquery-replicate-doing-an-excel-vlookup-in-m/

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.